sys.sp_delete_job

Description

Deletes a job from the SQL Server Agent service. The identification number of the job to be deleted. must be specified; both can’t be specified.

Syntax

sp_delete_job
[ [ @job_id = ]
'job_id'
]
[ , [ @job_name = ]
N
'job_name'
]
[ , [ @originating_server = ]
N
'originating_server'
]
[ , [ @delete_history = ] delete_history ]
[ , [ @delete_unused_schedule = ] delete_unused_schedule ]
[ ; ]

Examples

Example 1

sp_delete_job

Example 2

EXECUTE

Example 3

msdb

Example 4

sp_delete_job

Example 5

NightlyBackups

Example 6

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

Example 7

USE msdb;
GO
EXECUTE dbo.sp_help_job
@job_name = N
'NightlyBackups'
,
@job_aspect = N
'ALL'
;
GO