.Working with jobs when Agent is stopped.

Hi All,

How can I work with jobs when agent is stopped? This could be done in SQL
2000 Enterprise manager but does not appear to be available in Management
studio.

I don't want to start the Agent as this will run the jobs.

Thanks,
David


.

Relevant Pages

  • Re: SQL 2000 view current job status best practice
    ... Your asking for something that isn't doable in SQL Server ... solution to make the job status viewable from within SQL Enterprise Manager. ... jobs running on production SQL 2000 Servers. ...
    (microsoft.public.sqlserver.security)
  • SQL Server Agent hangs and becomes unresponsive
    ... I have my SQL Server and Agent both installed as a power use named ... "SQL_User", the jobs include some standard backup and maintenance plan jobs, ... Server Agent via Enterprise manager, which gives me a message that says it is ...
    (microsoft.public.sqlserver.server)
  • Re: .Working with jobs when Agent is stopped.
    ... I can create and edit a job, even though Agent service is stopped. ... Tibor Karaszi, SQL Server MVP ... This could be done in SQL 2000 Enterprise manager but does not appear to be available in Management studio. ... I don't want to start the Agent as this will run the jobs. ...
    (microsoft.public.sqlserver.tools)
  • Probleme nach Umbenennung
    ... SQL Query Analyzer folgende Befehle ausgeführt: ... SQL Server und Agent gestoppt und neu gestartet ... ich sie über den SQL Agent als Scheduled JOB ausführen lass geht es nicht. ... dass ich weder die alten Jobs noch neu erstellte Jobs ...
    (microsoft.public.de.sqlserver)
  • Re: how to remove scheduled backup tasks
    ... You need to refresh the screen in Enterprise manager for them to show up. ... Either close and re-open EM or right click on the Jobs folder and choose ... > still learning how to administer a SQL db using the SQL ... > created 2 backup jobs to backup the db at different times ...
    (microsoft.public.sqlserver.security)