November 10, 2014 at 2:45 am
Hi All,
Thanks in Advance.
How can we identify what ever the jobs are running out max time based on last run time. i want to get the alert if any jobs running morethan Max time. can anyone please provide the solution for this.
November 10, 2014 at 2:56 am
This script should do the trick for you:
http://thomaslarock.com/2012/10/how-to-find-currently-running-long-sql-agent-jobs/
-- Gianluca Sartori
November 10, 2014 at 4:38 am
Hi
It will give the information.On this case i need alert message through DB Mail
November 10, 2014 at 8:16 am
I'd take a look at extended events. You can just capture the events that exceed a certain value for run time and then have them forwarded to just about anything you want. Best would probably be to output to a file and have that file monitored by a powershell script that sends emails when it gets updated.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply