Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sql_er
Constraint Violating Yak Guru
267 Posts |
 Posted - 2007-02-09 : 15:51:40
|
| Guys,Does anyone have a script for identifying jobs which have a runtime being very close to the maximum alloted time for this job?More specifically, if a job is scheduled to run every 2 minutes and its runtime is close to 2 minutes, it would be helpful to know about it, especially if the runtime has a potential to increase, so that we can prevent clashes/job failures.Has anyone devised any solution for this problem or can advise any type of a solution?I am aware of different systables in msdb database (sysjobs, sysjobschedules), but cannot figure out how to put things together to achieve my goal.Thanks a lot for any pointers |
|
|
|
|
|
Identifying "about to become problematic" jobs