Start/Stop Job (SQL Agent Job)
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. | |
Preview |
Displays the DDL that will execute the object action. For details, see Preview. |
- 3. Click Execute. For information on the scheduling option, see Scheduling.