Posted in August 2014

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