Code is designed to consider the Expected Duration of job, and report number of times it has finished at various time threshold. Also, exception can be added for any job that should not be there in ‘Long Running Jobs’ mailer. To add this exception, simply set [Ignore] to 1 against [JobName] in table [dbo].[SqlAgentJobs] created for this alert.
I am Microsoft Certified Professional having 10+ years of experience in SQL Server Querying, Database Design, and Administration. I am fond of Query Tuning and like to automate things using TSQL & PowerShell. I also have experience of implementing end-to-end Data Warehouse solution, and Data Migration using ETL tools SQL Server Integration Services (SSIS), Pentaho Business Analytics, and have designed Database Inventory through PowerShell, Python, and Django etc.