Friday, December 24, 2010

Delete SQL Jobs

Want to get rid of the SQL Jobs in your SQL Server? All of them are stored in msdb. You would need to run the following queries to remove them. If there is a scheduled time that this job runs at, you would need to first remove that.




delete from msdb.dbo.sysjobschedules where job_id in (select job_id from msdb.dbo.sysjobs where name like '%JobName%')
delete msdb.dbo.sysjobs where name like '%JobName%'

No comments: