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

  • 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.