Enable/Disable 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_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

  1. Initiate an Enable/Disable Job 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 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.


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

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