Export (0) Print
Expand All

Disable or Enable a Job

This topic describes how to disable a SQL Server Agent job in SQL Server 2014 by using SQL Server Management Studio or Transact-SQL. When you disable a job, it is not deleted and can be enabled again when necessary.

In This Topic

Security

For detailed information, see Implement SQL Server Agent Security.

Arrow icon used with Back to Top link [Top]

To disable or enable a job

  1. In Object Explorer, connect to an instance of the SQL Server Database Engine, and then expand that instance.

  2. Expand SQL Server Agent.

  3. Expand Jobs, and then right-click the job that you want to disable or enable.

  4. To disable a job, click Disable. To enable a job, click Enable.

Arrow icon used with Back to Top link [Top]

To disable or enable a job

  1. In Object Explorer, connect to an instance of Database Engine.

  2. On the Standard bar, click New Query.

  3. Copy and paste the following example into the query window and click Execute.

    -- changes the name, description, and enables status of the job NightlyBackups.
    USE msdb ;
    GO
    
    EXEC dbo.sp_update_job
        @job_name = N'NightlyBackups',
        @new_name = N'NightlyBackups -- Disabled',
        @description = N'Nightly backups disabled during server migration.',
        @enabled = 1 ;
    GO
    

For more information, see sp_update_job (Transact-SQL).

Arrow icon used with Back to Top link [Top]

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft