Disable or Enable a Job

APPLIES TO: yesSQL Server yesAzure SQL Database (Managed Instance only) noAzure Synapse Analytics (SQL DW) noParallel Data Warehouse


On Azure SQL Database Managed Instance, most, but not all SQL Server Agent features are currently supported. See Azure SQL Database Managed Instance T-SQL differences from SQL Server for details.

This topic describes how to disable a SQL Server Agent job in SQL Server 2019 (15.x) 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.

Before You Begin


For detailed information, see Implement SQL Server Agent Security.

Using SQL Server Management Studio

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.

Using Transact-SQL

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 disables status of the job NightlyBackups.  
    USE msdb ;  
    EXEC dbo.sp_update_job  
        @job_name = N'NightlyBackups',  
        @new_name = N'NightlyBackups -- Disabled',  
        @description = N'Nightly backups disabled during server migration.',  
        @enabled = 0 ;  

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