Enable/Disable Job (SQL Agent Job)
Go Up to Available object actions by DBMS
This action builds and submits an sp_update_job call with an @enabled argument. It lets you change the enabled/disabled status of a SQL Agent job.
Platform Availability
To Change the Enabled/Disabled Status of a Job
- Initiate an Enable/Disable Job action against one or more jobs. For more information see Initiating an object operation.
- Use the following table as a guide to understanding and modifying settings in the Enable/Disable jobs wizard:
Step | Settings and tasks | |
---|---|---|
Action Options |
Select the Enable check box to enable the selected jobs. Deselect the Enable check box to disable 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.