AutoSys Job Scheduler

Here is a nice article about AutoSys job scheduler.

AutoSys is used for defining, scheduling and monitoring jobs. These jobs can be a UNIX script, java program or any other program which can be invoked from shell.

As a BI developer, it’s important to understand how AutoSys works at high level. To utilize AutoSys job scheduler, I would specify all the dependencies my process has. These will include any objects on SQL server and also on the host DBMS. Generally speaking, jobs that are scheduled through AutoSys will work more efficiently if the jobs are standalone jobs.

Job Scheduling – Write to a Load Stat Table

Job Scheduling – Notify on Failure

Here is the script for the job notification.

Job Scheduling – Wait for a load stats

Here is the procedure that “waits for”.

Job Scheduling – Skip a step on Weekends

if(datename(dw, getdate()) in (‘Sunday’, ‘Monday’))
    raiserror(‘it”s Sunday or Monday, skipping F report’, 11, 1)