How to Monitor the Job which is running out of max time

Question

Post reply

How to Monitor the Job which is running out of max time

Viewing 3 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

spaghettidba SSC Guru Points: 105732 More actions · Answer 1

This script should do the trick for you:

http://thomaslarock.com/2012/10/how-to-find-currently-running-long-sql-agent-jobs/

-- Gianluca Sartori

New persopn SSCarpal Tunnel Points: 4019 More actions · Answer 2

Hi

It will give the information.On this case i need alert message through DB Mail

Grant Fritchey SSC Guru Points: 399330 More actions · Answer 3

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