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,

1. Create the Stored Proceedure using the SQL in file create_sp_Email_Recent_Job_Failures
2. Execute the SP and be sure to pass in your semicolon (;) delimited list of email recepients.
3. You can optionaly pass in the number of days back to look for failed jobs.

  EXEC dbo.sp_Email_Recent_Job_Failures @to='[email protected];[email protected]' [, @NumberDaysBack = SMALLINT]

I'm currently using this in a SQL job that runs once daily, but you could run it more often.