sql-email-recent-job-failures
Will email the most recent SQL Job failures to a list of recipients. Tested in MS SQL 2005.
Usage is faily simple,
- Create the Stored Proceedure using the SQL in file
create_sp_Email_Recent_Job_Failures
- Execute the SP and be sure to pass in your semicolon (;) delimited list of email recepients.
- You can optionaly pass in the number of days back to look for failed jobs.
EXEC dbo.sp_Email_Recent_Job_Failures @to='me@mysite.com;you@yoursite.com' [, @NumberDaysBack = SMALLINT]
I'm currently using this in a SQL job that runs once daily, but you could run it more often.