Export (0) Print
Expand All

Delete One or More Jobs

This topic describes how to delete Microsoft SQL Server Agent jobs in SQL Server 2014 by using SQL Server Management Studio, Transact-SQL, or SQL Server Management Objects.

In This Topic

Security

Unless you are a member of the sysadmin fixed server role, you can only delete jobs that you own.

Arrow icon used with Back to Top link [Top]

To delete 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, expand Jobs, right-click the job you want to delete, and then click Delete.

  3. In the Delete Object dialog box, confirm that the job you intend to delete is selected.

  4. Click OK.

To delete multiple jobs

  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. Right-click Job Activity Monitor, and click View Job Activity.

  4. In the Job Activity Monitor, select the jobs you want to delete, right-click your selection, and choose Delete jobs.

Arrow icon used with Back to Top link [Top]

To delete 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.

    USE msdb ;
    GO
    
    EXEC sp_delete_job
        @job_name = N'NightlyBackups' ;
    GO
    

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

Arrow icon used with Back to Top link [Top]

To delete multiple jobs

Use the JobCollection class by using a programming language that you choose, such as Visual Basic, Visual C#, or PowerShell. For more information, see SQL Server Management Objects (SMO).

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