Home Forums SQL Server 2008 T-SQL (SS2K8) SQL PROCEDURE TO FIND THE LIST OF JOB FAILURES FOR CURRENT HOUR RE: SQL PROCEDURE TO FIND THE LIST OF JOB FAILURES FOR CURRENT HOUR
rj529
Ten Centuries
Points: 1194
More actions
December 10, 2012 at 10:14 am
#1567109
The reason is to just capture the reason why its failed and trigger a mail for every hour. The reason for truncating the temp table is to avoid the increase in size of the table or database.