Introduction

This Oracle by Example (OBE) provides instructions to configure, maintain, and monitor scheduled jobs over the web client using the Work With Scheduled Jobs program (P91300W).

In this OBE, you will:

  • Schedule a job using the web client.
  • Update all scheduler passwords for the user.
  • Configure to skip the scheduled jobs on restarting the scheduler kernel.
  • Rename the scheduled job
  • Revise the status of the scheduled job.
  • Copy the scheduled job to create a new job.
  • Manage and add scheduler servers.

Time to Complete

0.5 to 1 hour.

Background

Starting with Tools Release 9.2.26.0, you can create, manage, and monitor scheduled jobs entirely through the web client, without needing to use the development client. The Work With Scheduled Jobs program (P91300W) is the web version that provides the same functionalities as the Windows development client version.

Prerequisites

Before scheduling and configuring a job, ensure that you:

  • Select the timezone in which you want the job to run. On the Work With Versions form, select the version that specifies the time zone in which the scheduled job will run. 
  • Set up and select the daylight savings rule to adjust time for a geographic and political locale, if applicable.

    Note:

    For daylight saving time to be displayed correctly, ensure that daylight saving rules are defined in P00085 (Work With Daylight Savings Rules) and that the correct rule name is referenced in the P91300W processing option for daylight savings.

Create an Interactive Version of P91300W

For the purpose of this OBE, you will create a version of Webify Scheduler (P91300W) named IST (Indian Standard Time) using time zone 14 and no daylight saving to reflect IST:

  1. Enter IV in the Fast Path to access the Work With Interactive Versions form.
  2. Enter P91300W in the Interactive Application field and click Find.
  3. Click Add to create a new version.
  4. On the Add Interactive Application Version form, add the Version as IST and Version Title as Indian Standard Time and click OK. For more information on the fields in this form, see Creating (Adding) an Interactive Version.
  5. On the Work With Interactive Versions form, select IST in the grid and then select Processing Options from the Row menu.
  6. On the Display tab, set View Local Time value to 2 and set the Local Time Zone value to 14 for IST. 
  7. Set up the other processing options as required. For more information, see Setting Processing Options for the Job Scheduler.

Task 1: Scheduling a Job Using the Web Client

  1. Enter P91300W|IST in the Fast Path to access the web version of the Work With Scheduled Jobs form for the Indian Standard Time (IST) timezone.
    Fast path to P91300W
    Fast Path to P91300W
  2. On the Work With Schedule Jobs form, click Add.
    Work With Scheduled Jobs
    Work With Scheduled Jobs Form
  3. On the Schedule Information Revisions form, in the Scheduled Job Name field, enter DEMO_BYDAY.

    Note:

    Enter a name that uniquely identifies to the system and the user of a scheduled job. Use this name to indicate the job function, such as Monthly Close or Nightly BackUp.
    Schedule Information Revisions Form
    Schedule Information Revisions Form
  4. In the Scheduled Job Status field, select the status of the scheduled job.
    As long as the status is Active, the Scheduler determines if the job should be submitted to the server for processing. When the scheduled end date for the job is reached, no more occurrences are created in the Job Schedule table (F91320). The job header in F91300 remains in the active status and can be edited to add more occurrences.

    To stop the Scheduler from running the job, you can change the status to Inactive at any time prior to the end date. You can reactivate the job if you want the Scheduler to include the job again.

    • If the job is not set to skip jobs on reactivation, all previous missed instances will be run.
    • If the job is set to skip jobs on reactivation, the scheduler will run only the most recent pending instance and skip the others. It will then continue scheduling future jobs if the job has not past its end date (if an end date is defined).

  5. In the Scheduled Batch Application field, specify the object name of the report that the Scheduler submits to the server.
  6. In the Scheduled Version field, specify the version of the report that is scheduled to run. A version identifies a specific set of data selections and sequencing settings that the batch job uses.
  7. In the Scheduled Start Date/Time field, determine the next date on which the Scheduler submits the scheduled job to the server for execution.
  8. In the Scheduler Logical Server field, select the logical data source of the server where the scheduler kernel submits the job. This server may not be the server running the scheduler kernel.
  9. Enter the Port Number.
  10. Select the Allow job to be skipped on startup checkbox to skip missed instances of the job.
  11. Select Recurrence from the Form menu.
  12. In the Recurring Scheduling Information Revisions form, set the Scheduled Start Date and the frequency of the schedule.
    Recurring Scheduling Information Revisions Form
    Recurring Scheduling Information Revisions Form
  13. Click OK.
  14. On the Schedule Information Revisions form, click OK to schedule the job.

Task 2: Updating All Scheduler Passwords for the User

When setting up or changing the job schedule password for a user, you can enable the option to simultaneously update all associated job passwords for that user in the scheduler table. This option makes it easier for you to manage job passwords when using external login security such as LDAP.

  1. Access the Work With Schedule Jobs form.
  2. On the Work With Schedule Jobs form, select the job schedule you created DEMO_BYDAY and click OK.
    Work With Schedule Jobs Form
    Work With Schedule Jobs Form
  3. On the Schedule Information Revisions form, select Advanced Options from the Row menu.
    Schedule Information Revisions Form - Advanced Options
    Schedule Information Revisions Form - Advanced Options
  4. On the Scheduling Advanced Options form, select the Launch Overrides tab.
  5. Select the Launch Overrides tab.
  6. Select the Update all scheduler passwords for this user checkbox.
    Scheduling Advanced Options Form - Launch Overrides Tab
    Scheduling Advanced Options Form - Launch Overrides Tab
  7. Click OK.

Task 3: Skipping a Scheduled Job on Restarting the Scheduler Kernel

As a system administrator, you can choose to skip missed instances of scheduled jobs on restarting or reactivating the scheduler kernel. These missed instances may have occurred due to scheduled downtime or because the job was previously set to Inactive status. Skipping missed job instances ensures that multiple instances of the same job are not launched when you restart the scheduler kernel.

On choosing to skip missed instances of a job, the most recent of the previous occurrences is run and the others are set to Status 31 – Skipped on scheduler startup or to Status 33 – Skipped on job activation.

To set the scheduler kernel to skip missed instances of a scheduled job at the job level:

  1. On the Work With Schedule Jobs form, select the job schedule you created DEMO_BYDAY and click OK.
    Work with Schedule Jobs Form
    Work With Schedule Jobs Form
  2. On the Schedule Information Revisions form, select the Allow job to be skipped at startup checkbox.
    Schedule Information Revisions Form
    Schedule Information Revisions Form
For new jobs, to set the scheduler kernel to skip missed jobs at startup by default:
  1. In the processing options for Webify Scheduler (P91300W), go to Defaults tab.
    The exp_set file
    Work With Interactive Versions Form
  2. Set the value for Allow scheduled job to be skipped at start up of scheduler service to 1.
    P91300W Processing Options - Defaults Tab
    P91300W Processing Options - Defaults Tab

Task 4: Renaming the Scheduled Job

In the renaming process, the system first changes the status of the job in the Schedule Job Master table (F91300) to 03 (Rename job is processing) and then renames the job records in the Schedule Job Master table (F91300), Scheduled Job Parameters table (F91310), Job Schedule table (F91320), and the Scheduled Job Override Print Info table (F91330).

  1. Access the Work With Schedule Jobs form.
    Work with Schedule Jobs Form
    Work With Schedule Jobs Form
  2. Select the job from the grid and select Set Job Inactive from the Row menu.
    Work with Schedule Jobs Form - Set Job Inactive
    Work With Schedule Jobs Form - Set Job Inactive
  3. Select Rename Job from the Row menu.
    Work With Schedule Jobs Form - Rename Job
    Work With Schedule Jobs Form - Rename Job
  4. On the Rename Schedule Job form, enter the new job name DEMO_BYWEEKDAY.
    Rename Schedule Job Form
    Rename Schedule Job Form
  5. Click OK. The job is renamed and the status of the job is set back to 02 (Scheduled - Inactive).
  6. On the Work With Schedule Jobs form, review the scheduled jobs for the renamed job in the Scheduled Jobs tab of the Job Details pane.
    Work With Schedule Jobs Form - Renamed Schedules Jobs
    Work With Schedule Jobs - Renamed Schedules Jobs

Task 5: Revising the Status of the Scheduled Job

You can change the status of a scheduled job to inactive if you do not want the job to be processed.

  1. On the Work With Schedule Jobs form, select the job DEMO_BYWEEKDAY, and then select Job Revisions from the Row menu.
  2. On the Schedule Information Revisions form, modify the Scheduled Job Status as necessary.
    Schedule Information Revisions Form
    Schedule Information Revisions Form
  3. Click OK.

    Note:

    These advanced job schedule statuses in the help in improving the performance of the Scheduler Kernel.
    • 02 – Scheduled – Inactive (inactive jobs with scheduled instances)
    • 19 – Job terminated by user
    • 31 – Skipped on scheduler startup
    • 32 – Job not found by monitor
    • 33 – Skipped on job activation (If a job is set status 33, the most recent of the scheduled job occurrences run immediately while the others are set to status 31 or 32.)
    • 34 – Orphaned (jobs without a matching P91300 record)

Task 6: Copying the Scheduled Job

To copy the job DEMO_BYWEEKDAY you created and create a new job schedule with the same time and occurrence information:

  1. On the Work With Schedule Jobs form, select the job DEMO_BYWEEKDAY, and then select Copy from the Row menu. The system creates a new job schedule using the information from DEMO_BYWEEKDAY.
    Work With Schedule Jobs Form
    Work With Schedule Jobs Form
  2. On the Schedule Information Revisions form, enter the Scheduled Job Name and revise the job schedule as required.
    Schedule Information Revisions Form
    Schedule Information Revisions Form
  3. Modify other characteristics of the job being copied, such as Scheduler Batch Application, as desired.
  4. Click OK.

Task 7: Managing the Scheduler Servers

You can view all the server and port number combinations on the web-based Work With Scheduler Server Control form (P91301W). The multi-foundation scheduler kernel allows to have multiple servers on the same port and multiple instances of ports on the same machine.

  1. On the Work With Schedule Jobs form, select Schedule Servers from the Row menu to access the Work With Scheduler Server Control form (P91301W).
    Work With Schedule Jobs Form
    Work With Schedule Jobs Form
  2. Click Find on the Work With Scheduler Server Control form, to view all the server and port number combinations.
    Work With Scheduler Server Control Form
    Work With Scheduler Server Control Form
  3. To start a server, select the server on the grid and then select Start Scheduler from the Row menu.
  4. To stop a server, select the server on the grid and then select Stop Scheduler from the Row menu.
  5. To add a new server, click Add on the Work With Scheduler Server Control form.
  6. On the Server Control Revisions form, enter the Scheduler Server Name and Port Number details and click OK.
    Server Control Revision Form
    Server Control Revision Form

More Learning Resources

For more learning resources, visit LearnJDE

For product documentation, visit JD Edwards on Oracle Help Center.