Tag: Script

Script to find orphaned/unreachable job steps within your SQL jobs
By Art on August 24, 2012

SQL jobs are great as the SQL agent job engine allows for very granular control over jobs that are created by allowing great flexibility with the scheduling, execution, flow actions and notifications. Invariably, when jobs are setup, they just run and run without many problems, but the other day I was called in to look at a problem where a […]

Read More
Script to analyse space usage by your Service Broker
By Art on April 16, 2012

I believe that service broker is one of the best features from SQL server 2005, well along with the xml data type, and I use service broker a lot for messaging between solutions. Over the years it has proven to be extremely reliable; only really stopping because of a poison message or other environment type issue outside the control of […]

Read More