Eugene Elutin (3/20/2013)
Well, this SP should be pulling the job tables every 5 min or so and seeing if any are running longer than defined SLA for that job, so, if the SP finds that any job is running longer than its defined SLA, it should trigger the .bat job and .bat job will create an automated ticket using our monitoring tool. Let me know if you have a better idea.
SueTons.
How are you going to schedule your sp to pull job tables every 5 min?
The best way will be if your sp will return some state, which will be a signal for the next step to run your batch file.
Actually, I am trying to help out a developer who created the SP, I don't have the SP handy. So, how can I incorporate xp_cmdshell 'c:\MyBatch.bat' within the SP? Maybe I am asking a bit too much, hope you don't mind.
SueTons.
Regards,
SQLisAwe5oMe.