Start/Stop Job (SQL Agent Job)

From DBArtisan
Jump to: navigation, search

Go Up to Available object actions by DBMS

This action builds and submits an sp_start_job or sp_stop_job call for one or more SQL Agent jobs. It lets you immediately start or halt execution of a job.

Platform Availability

To Immediately Start or Halt Execution of One or More Jobs

1. Initiate a Start/Stop action against one or more jobs. For more information see Initiating an object operation.
2. Use the following table as a guide to understanding and modifying settings in the Start/Stop jobs wizard:
Step Settings and tasks

Action Options

Select the Start check box to start the selected jobs. Deselect the Start check box to stop the selected jobs.


Displays the DDL that will execute the object action. For details, see Preview.

3. Click Execute. For information on the scheduling option, see Scheduling.