SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin. Search for scripts directly from SSMS, and instantly access any saved scripts in your SSC briefcase from the favorites tab.
Download now (direct download link)

Intervention system for runaway jobs

By Johan Bijnens,

Some of my developers had created jobs that executed VB applications that never ended.
Aparently they could not figure out when, why and what was going wrong. They could not repro the situation.
Now I've created this litle system so the users can assign max elaps times for their jobs. These jobs will then be intercepted and interrupted with brute force sp_stopjob.

As always with this kind of stuff : don't use it if there's no explicit reason to use it. If you have to use it, always test it before you put it in a production environment.

Total article views: 457 | Views in the last 30 days: 2