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 Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply