Once again thanks for your help! - SQL Server 2000
I have a situation where I am wanting to look at scheduled jobs currently
running on a server. To do this I am using sp_help_jobs.
My aim is to be able to select the scheduled jobs that are currently running
and compare the length of time they have been running with the maximum time
I enter in a control table. If this has been exceeded I will then stop the
job, maybe re-start it but definitely send a warning mail.
I know how to do this is principle and ...