Job Stored Procedures

I am constantly having to search for stored procedures to manipulate SQL Agent jobs.  Here is a list that I have used recently.


USE msdb ;
GO
EXEC dbo.sp_delete_job @job_name = N'<job name>' ;
GO
EXEC dbo.sp_purge_jobhistory @job_name =  N'<job name>' ;
GO
EXEC dbo.sp_start_job @job_name =  N'<job name>' ;
GO
EXEC dbo.sp_help_job @job_name = N'<job name>' ;
GO

Posted in SQL

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow SQL Uber Geek on WordPress.com
Try Audible and Get Two Free Audiobooks
%d bloggers like this: