Looking for T-SQL scripts to delete a SQL Job

Question

If I know the database server name, instance name and the SQL Server job name, how to delete a SQL Server job by its name in a simple way? I am writing scripts which will be called by sqlcmd to delete SQL jobs.

Appreciate if anyone could show me a sample? :-)

thanks in advance, George

score 16 · Accepted Answer · edited Sep 27 '13 at 19:40

16

USE msdb;

GO

EXEC sp_delete_job
    @job_name = N'NightlyBackups' ;

GO

edited Sep 27 '13 at 19:40

Oleks

31,955
11
77
132

answered Aug 02 '09 at 16:28

Sergey Olontsev

1,084
7
19

score 3 · Answer 2 · answered Aug 02 '09 at 16:20

3

You're looking for sp_delete_job:

[srv].[master].[dbo].sp_delete_job @job_name = 'MyJob'

So this four part name only works with linked servers. Otherwise, you'll have to connect to the server, and run that command against it (with everything right of [dbo]..

answered Aug 02 '09 at 16:20

Eric

92,005
12
114
115

1

How about just execute USE msdb ; GO EXEC sp_delete_job @job_name = $(Job name here); GO – George2 Aug 02 '09 at 16:26

score 2 · Answer 3 · edited Jan 26 '11 at 21:58

2

It's worth noting that you can just use SSMS, choose the job, right-click and pick "Delete", and then use the Script button at the top of the dialog box to generate a script like the ones suggested here.

edited Jan 26 '11 at 21:58

Paul Sasik

79,492
20
149
189

answered Aug 03 '09 at 02:28

Rob Farley

15,625
5
44
58

Looking for T-SQL scripts to delete a SQL Job

3 Answers3