Command line stored procedures

There are two methods for creating a scheduled job: by specifying both the job and schedule information in one operation, or by defining the job and the schedule separately and then combining them into a scheduled job.

Stored procedures are provided for the command line interface to obtain information about the jobs and schedules configured in the Job Scheduler database. The information can be provided in a formatted report or as a simple list.

You can run jobs by scheduling them or using ad hoc commands.

It is possible to manage job history and job output separately. Deleting job history also deletes any corresponding job output, but deleting job output records does not delete job history. This flexibility allows for different rules to govern how much job history and job output is retained.

Job Scheduler users without the js_admin_role are restricted to viewing and manipulating the job history and job output from jobs which have their user name recorded in the history entry. However, a user with js_admin_role can use the all option to override this limitation and extend the scope to the history and output to all Job Scheduler users.