View Source

The scheduler is accessible by clicking the Scheduler button from the toolbar. It is also available as a stand alone utility. In this way, operators can be given access to the scheduler without gaining full access to the data warehouse.
The scheduler runs on either a UNIX host or under Windows (as a system service). It processes predefined jobs, recording the success, failure, or otherwise of the job.

Audit trail
Specific information relating to the tasks in the job is recorded in the audit trail. Generally, only summary information is written on this audit trail. The contents of the audit trail are maintained even after a job is deleted.
Error trail
Detail or error information is written to the error trail. The contents of the error trail are deleted when the job is deleted.
Administration Views
It is possible to view the status of a job without using the WhereScape RED product. Three views are provided to assist in this undertaking. They are ws_admin_v_audit, ws_admin_v_error and ws_admin_v_sched. Queries can be issued using these views to see the results or status of a job.

An example of the Scheduler screen is shown below.

Toolbar/Jobs menu

Quick access to some job categories is in the toolbar. The complete options are listed under the Jobs menu and while most are self-explanatory they are described below:

Object	Description
Job Name Filter	Lists the jobs whose names match the filter supplied. This filter only works as an appended filter to the main filter selected under Jobs, e.g. first enter a filter for Job Name Filter or select a filter from the drop-down list; and then choose your main filter under Jobs—e.g. All Jobs, Scheduled Jobs, etc.
All jobs	Lists all jobs in the middle pane
Scheduled	Lists the jobs that are waiting to run or are on hold.
Run/Fail	Lists the jobs that are running and those that have failed.
My Jobs	Lists the jobs you have scheduled or have run.
Today	Lists the jobs you have scheduled for today.
Last 24 hours	Lists the jobs that have run or started to run during the last 24 hours.
Prior 24 hours	Lists the jobs that ran during the previous 24 hours.
This Weeks Jobs	Lists the jobs that have run or are scheduled to run during the current week
Last Weeks Jobs	Lists the jobs that ran during the last week.
Recent log entries	Displays the Audit and Scheduler log which details the audit trail information of a task/job.
Scheduler status	Lists all schedulers and displays their current status. The status is updated every few minutes, and a right menu option enables the polling of a scheduler for status, and the termination of a scheduler.

Top pane

The top pane shows the details of the jobs. Information covers:

Column	Description
Job name	The name given to the job when created.
Status	The status of the job. Refer to the following section for the various status values.
Sequence	This is a unique number assigned to each job iteration and job. If you enter a new job, it acquires a new sequence number. In normal daily processing when no new jobs have been created, sequence numbers will be sequential.
Start and Finish times	The start and finish dates and times for the job.
Elapsed time	The time that elapses from start to finish of a job.
Ok	These are success messages written to the audit trail.
Info	Informational messages written to the audit trail about the running of the job.
Detail	Lines written to the detail or error logs.
Warn	The number of warnings written to the audit trail.
Error	The number of error messages written to the audit trail.
Who	The initials of the person who scheduled the job.

Additional fields can be added via the Tools > Select Job Report Fields option.

Middle pane

The middle pane shows the tasks related to a selected job. Task information available includes:

Column	Description
Task	The object name.
Action	The action to be done to the object.
Status	Status of the task.
Sequence	This is a unique number assigned to each job iteration and job. If you enter a new job, it acquires a new sequence number. In normal daily processing when no new jobs have been created, sequence numbers will be sequential.
Start and Finish times	As the names suggest, the start and finish dates and times for the task
Elapsed time	The time that elapses from start to finish of a task.
Info	Informational messages written to the audit trail about the running of the job.
Detail	Lines written to the detail or error logs.
Warning	The number of warnings written to the audit trail.
Result	Result of the task.

Additional fields can be added via the Tools > Select Task Report Fields option.

Bottom pane

The bottom pane shows the audit trail of a selected task/job. Audit trail information includes:

Column	Description
Task	The object name.
Status	The status of the message.
Sequence	This is a unique number assigned to each job iteration and job. If you enter a new job, it acquires a new sequence number. In normal daily processing when no new jobs have been created, sequence numbers will be sequential.
Timestamp	Time of message output.
Message	The message.
DB Message	Message from database.
Job	Job relating to this message.