Contents of the Start/Stop Job Server Screen

Use the fields and options to configure the Start/Stop Job Server screen.

Job Servers

Use this block to view job server information and, optionally, select the daily shutdown and startup times.

Field Description
Server Name

This field displays the name of this job server. This is a predetermined name assigned to the WebLogic server during installation.

Status

This field displays whether a job server is currently Runningor Not Running.

Destination Server

Use this field to enter a valid Java Messaging Service (JMS) queue to which all the job queues in this job server is sent for processing. This way, jobs assigned in this server are processed by a dedicated hardware. Leave this field blank to process the job queues via the default JMS system messaging queue.

Daily Shutdown Time

Use this field to enter the scheduled time each day at which this job server should stop polling the database for the next scheduled job. Use the standard hh:mm:ss AM/PM format, where hh = hour, mm = minute, and ss = second (HH:MM:SS AM or PM).

If you enter data in the Daily Restart Time field, entry in this field is required.

Daily Restart Time

Enter the scheduled time each day at which the job server should restart polling the database for the next scheduled job. Use the standard hh:mm:ss AM/PM format, where hh = hour, mm = minute, and ss = second (HH:MM:SS AM or PM).

If you enter data in the Daily Shutdown Time field, entry in this field is required.

Start

Click this button to start the selected job server. This makes the job server available for processing jobs.

Stop

Click this button to stop the selected job server. This makes the job server unavailable for processing jobs.

Available Job Queues

This table window displays all available job queues across all available servers.

Field Description
Job Queue

This field displays the identification code of this queue.

Process Sequentially

This field displays Y if this queue has been enabled to process jobs sequentially in the job server. Otherwise, this field displays N.

You can enable/disable sequential processing for a job queue by selecting the Process Sequentially check box in the Manage Job Queues screen.

Use Parallel SQL

This field displays whether parallel SQL is enabled (Y) or disabled (N) for a job queue. This option is available only if you are using Oracle DBMS. For other DBMS like MS SQL Server, this option does not display.

You can enable/disable parallel SQL for a job queue by selecting the Use Parallel SQL check box in the Manage Job Queues screen.

Select

Click this button to add the selected job queue to the selected server in the Job Servers block. The selected job queue is then displayed in the Assigned Job Queues table window.

Assigned Job Queues

Field Description
Job Queue

This field displays the identification code of this queue.

Active for Server

Select this option to make this queue active for the server.

Click to save any change in this queue's activity status to the database (JOB_QUEUE_LIST table).

Process Sequentially

This field displays Y if this queue has been enabled to process jobs sequentially in the job server. Otherwise, this field displays N.

You can enable/disable sequential processing for a job queue by selecting the Process Sequentially check box in the Manage Job Queues screen.

Use Parallel SQL

This field displays whether parallel SQL is enabled (Y) or disabled (N) for a job queue. This option is available only if you are using Oracle DBMS. For other DBMS like MS SQL Server, this option does not display.

You can enable/disable parallel SQL for a job queue by selecting the Use Parallel SQL check box in the Manage Job Queues screen.