or 
to select a queue to populate the screen.Use this screen to create job queues and manage their entries. Like the Update Job Status screen, this screen provides information on the status of a particular queue, the job server processing the jobs, and the jobs that the queue contains. If you have function rights to this screen, you can update any processes waiting for execution on the process server. (This is one of the significant differences between the Update Job Status screen and this screen.) In addition, you can create new queues or change the status of existing queues.
Before a job appears on this screen, you must submit it to the queue using the Submit Job to Queue screen. The jobs that have been submitted to the queue appears on this screen flagged with any of the following statuses:
Executing — This status indicates that the scheduled job is currently processing. You cannot edit this job while it is still processing. Jobs with this status will be set to Aborted when a server is brought up with the same ID.
Aborted — This status indicates that the scheduled job did not finish successfully.
Hold — This status indicates that the scheduled job is currently on hold for processing.
Pending — This status indicates that the scheduled job is not yet started.
You cannot enter new jobs in this screen. You can only update or delete processes sent to the queue if Aborted, Hold, or Pending appears in the Status field. After you update or delete the jobs in this screen, save the screen to retain any changes. The Server and Status fields are non-editable. You can make changes to the attached server or to the server's status in the Update Job Queue Status screen.
You must first create a job in the Manage Jobs screen before you can use this screen. After you create the job, you can send it to the queue using the Submit Job to Queue screen. You can click or to select a queue to populate the screen.
If you send a job to the queue and its status is Pending, the Start Time and Start Date determine when the job is executed on the job server.
Use this block to select a job queue, specify whether jobs should be run sequentially or in parallel (Oracle DBMS only), and view the activity of the attached job servers.
Use this group box to specify a job queue ID.
When creating a new queue, use this field to enter an identification code for this job queue.
To use existing queues, use this field to search for and select a queue ID.
Select this check box to enable sequential job processing for this queue.
Select this option to enable parallel query and parallel DML. This option is available only if you are using Oracle DBMS. For other DBMS such as MS SQL Server, this option does not display.
Parallel query is a technique the DBMS uses to improve performance by breaking down tasks into smaller subtasks and executing them in parallel. Parallel DML complements parallel query by providing both querying and updating capabilities for DSS databases, thus, speeding up large DML operations against large database objects.
Parallel execution can be enabled at 3 different levels:
Session Level (connection time)
Table or Index Level (creation time)
Statement Level (statement execution)
Performance gain varies according to the type of SQL operation. It is significant in the following:
Decision Support Systems (DSS)
Data Warehousing Operations
Batch Processing
Jobs must be submitted through the Process Server. Oracle automatically performs the SQL statements that involve SELECT operations in parallel mode.
Certain hardware requirements must be met. Requirements include:
Symmetric multiprocessors (SMP)
Clusters or massively parallel systems
Sufficient I/O bandwidth
Underutilized CPU.
Use this table window to view all the job servers attached to this job queue.
This field displays the servers associated with this job queue ID.
This field displays Y if this job server is active. Otherwise, this field displays N.
Use this table window to view and modify the details of scheduled jobs.
This field displays the job ID of each job that has been submitted to the queue.
This field displays the description of the job ID in the Job field. Job descriptions are set up in the Manage Jobs screen.
This drop down list box displays the current status of the job. They are as follows:
Scheduled — The job is executed as soon as it reaches the top of the entry list and a server is available.
Hold — The job is not executed until you change the status to Scheduled.
Executing — The job server is currently processing this job. You cannot change the status in this circumstance.
Aborted — The job was submitted but was not executed successfully. You cannot change the status of an Aborted job, but you can delete the entry.
Queued — The job was submitted and is currently queued for processing.
Suspended — The job was submitted but is currently suspended to be processed at a future date and time.
Canceling — The job was submitted and processed and is currently being cancelled by Costpoint.
You can change the status of a job by selecting one of the options from this drop-down list box.
To execute a job, select Scheduled from this drop-down list and enter the scheduled date and time in the Start Date and Start Time fields, respectively.
If you change the status from Scheduled to Hold, Costpoint automatically clears the data in the Start Date and Start Time fields after you save this job queue.
If you change the status from Hold to Scheduled and you have not entered a start date or time, Costpoint automatically enters the current date and time in the Start Date and Start Time fields you save this job queue.
Use this field to enter, or click 
to select, the scheduled date on which to execute this job on the job server.
If you selected Start Time/Date from the Execution Option drop-down list box in the Submit Job to Queue screen, Costpoint automatically displays that date in this field. You can edit this default data.
If you enter data in the Start Time field, entry in this field is required.
Use this field to enter the scheduled time at which to execute this job on the job server. Use the standard hh:mm:ss AM/PM format, where: hh = hour, mm = minute, and ss = second.
If you selected Start Time/Date from the Execution Option drop-down list box in the Submit Job to Queue screen, Costpoint automatically displays that time in this field. You can edit this default data.
If you enter data in the Start Date field, entry in this field is required.
This field displays the default priority level for this job. The priority level can be any number from 1 (highest) to 99 (lowest). The job server determines which jobs to process first based on this priority level.
If this is to be a recurring job, use this field to enter the number of hours, days, weeks, or months to on which this job must recur after it has been initially executed on the job server.
If you enter data the Recurring Timeframe field, entry in this field is required.
Use this drop-down list box to select the frequency of recurrence (Hours, Days, Weeks, or Months) for this job.
If you enter data in the Recur Every field, entry in this field is required.
Use this field to enter, or click to select, the date on which this recurring job should end. This field is only available for recurring jobs.
If you enter data in the End Time field, entry in this field is required.
Use this field to enter the scheduled time at which to end the recurring job on the job server. Use the standard hh:mm:ss AM/PM format, where hh = hour, mm = minute, and ss = second. This field is only available for recurring jobs.
If you enter data in the End Date field, entry in this field is required.
This field displays the ID code of the user who submitted the job to the queue.
This field displays the date and time that the job was submitted to the queue.
Click this button to cancel the selected job in the table window.
|
Subtask |
Description |
|
Scheduled Job Steps |
Click this link to open the Scheduled Job Steps subtask and view the status of all operations that are scheduled within the selected job. |