Export (0) Print
Expand All

Running Jobs

Updated: 14 April 2006

You may need to run a job often, but not regularly. In such cases, instead of scheduling a job, you can simply run it manually as needed. You can also run jobs manually that have an assigned schedule. For example, even though you have scheduled a master database backup job to occur in the evening, you may want to back up the database immediately after making changes to the instance configuration.

A SQL Server instance can only run one instance of a job at a time. If a job has started according to its schedule, you cannot start another instance of that job on the same server until the scheduled job has completed. In multiserver environments, every target server can run one instance of the same job simultaneously.

You can disable a scheduled job you do not want to run. You can also stop a job while it is running. In most cases, when you issue a stop command, the current job step is canceled and any retry logic is ignored. Some job steps, such as long-running Transact-SQL statements (BACKUP) or some DBCC commands, may not respond quickly to stop requests. When you stop a job, a "Job Canceled" entry is recorded in the job history.

A multiserver job is a job that a master server runs on one or more target servers. Each target server periodically polls the master server, downloads a copy of any new jobs assigned to the target server, and then disconnects. The target server runs the job locally and then reconnects to the master server to upload the job outcome status when finished.

ms190741.note(en-US,SQL.90).gifNote:
If the master server is inaccessible when the target server attempts to upload job status, the job status is spooled until the master server is accessible again.

Release History

14 April 2006

Changed content:
  • Removed the note about why jobs that use proxies may fail to run, which was added for the SQL Server 2005 Books Online 5 December 2005 release. This issue has been fixed in SQL Server 2005 Service Pack 1.

5 December 2005

New content:
  • Added a note about why jobs that use proxies may fail to run.
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft