DECLARE @Jobname Varchar(50)
DECLARE @Jobid binary(16)

Set @Jobname = N’ESB_LaSalle-Loan-Removal-Monthly’
SELECT @Jobid = job_id FROM msdb.dbo.sysjobs WHERE (name = @Jobname)
select ‘job1’, @jobid, @jobname
IF (@jobId IS NOT NULL)
exec sp_delete_job @job_name=@Jobname;

Related posts:

  1. Mass Delete of Old Rows in T-SQL
  2. BizTalk: Errors exist for one or more children
  3. Identifier “abc” does not exist in ‘global_NS.Appname”; are you missing an assembly reference?
  4. Powershell – Verify if all disk-paths in a file exist

Tagged with: • • •

Filed under: SQL