How many times have you seen SQL Agent jobs with random ownership? It can be very frustrating when you are trying to keep things standardised and new agent job creations are not being set to an owner which is part of your Standardisation. There are times when you may want to have certain jobs... Continue Reading →
Sometimes you may find that people add SQL agent operators, these same operators may at some point need a clear down but what do you do when the operator you want to delete is set as the notification operator for numerous other jobs? You use the GUI , Right click the operator and click... Continue Reading →
Update: 07/08/2017 - Identified and fixed a bug with the Elapsed Days not showing accurately. Update: 31/7/2017 - We have improved the Stored Procedure, the revised version now includes Days elapsed in addition to Hours, Minutes and Seconds. There are quite a few Running agent job scripts out there , most of the ones I... Continue Reading →
SQL Undercover 