Query to get status of all jobs in Autosys


The below query will help to find the status of jobs in Autosys. You need to run the query against the SQL Server database backend of Autosys. In the query I have declared a variable @GMTOffset. To get the GMTOffset value you can get the Offset value from the table “ujo_alAmOde”. Declare @GMTOffset int; select … Continue reading

April #Meme15 : Blogs that stand out


This is my first entry towards #Meme15 and this month’s #Meme15 by Jason Strate (Blog|Twitter)  is about 10 blogs that has outstanding information about SQL Server. Well there is enormous amount of information available through different blogs and many of the blogs are followed globally, I am listing few which are Gems and contain information that … Continue reading