Oracle by Example brandingCreating and Submitting to Non-Default Job Queues

section 0Before You Begin

This 20-minute tutorial shows you how to create and submit to job queues in a virtual batch queue environment.

Background

Virtual batch queues will enable EnterpriseOne to meet cloud elasticity needs for batch processing. By using a virtual host name, you can tie multiple EnterpriseOne batch processing servers to that virtual host name to facilitate simple scaling of EnterpriseOne batch processing. For example, a job submitted to QBATCH on one enterprise server could be processed by any physical node on that virtual host.

What Do You Need?

You must have completed the following tasks:

  • All servers must be on Tools Release 9.2.5 or higher and the latest Tools ESU must have been applied.
  • All servers used in a batch cloud must be on the same operating system, database type, and on the same port.
  • All servers used in a batch cloud must have the File in Database enabled.
  • All servers used in a batch cloud must share the same server map, SY or SVM, and packages.
  • Required print queues must be set up identically.
  • Security servers must have been federated to accept the same tokens.
  • Unused columns with obsolete data must be cleaned from F986110.

section 1Creating Job Queues

  1. From the Fast Path, run application P986130 – Work with Job Queues.
  2. On the Work with Job Queues form, select Virtual Host Queues from the Form menu.
  3. Form Menu
    Form Menu
  4. Enter vbqcloud in the Virtual Host Name field and click Search.
  5. Work With Virtual Hosts Job Queues Form
    Work With Virtual Hosts Job Queues Form
  6. On the lower part of the powerform, click Add.
  7. Work With Virtual Hosts Job Queues Power Form
    Work With Virtual Hosts Job Queues Power Form
  8. Add the QBATCH01 queues on hosts jdeent1-2 and jdeent1-3 and click OK.
  9. Job Queue Revisions Form
    Job Queue Revisions Form
    Job Queue Revisions Form
    Job Queue Revisions Form
  10. Click Close after adding both the queues.
  11. Your Actual Host Job Queues Form should look like this:

    Work With Virtual Hosts Job Queues Power Form
    Work With Virtual Hosts Job Queues Power Form


section 1Creating a New R0008P Version

In this task, you will learn how to create a report version that you will use for this OBE . The newly created version will be used in the rest of this OBE as the report version for all the jobs that you will submit.

  1. From the Fast Path, run the application BV – Batch Versions.
  2. Enter R0008P in the Batch Application field and click Search.
  3. Click Add to add your version.
  4. Batch Versions - Work With Batch Versions - Available Versions Form
    Batch Versions - Work With Batch Versions - Available Versions Form
  5. Enter the following values and click OK.
    • Version: TRAIN01
    • Version Title: TRAIN01 Exercise version
  6. Batch Versions - Add Version Form
    Batch Versions - Add Version Form
  7. Click Search.
  8. Your Work With Batch Versions Form should look like this:

    Batch Versions - Work With Batch Versions - Available Versions Form
    Batch Versions - Work With Batch Versions - Available Versions Form

section 1Submitting Version Specs to the Server by Overriding the Job Queue

In this task, you will learn how to submit new version specs for a report to a non-default job queue by overriding the job queue during report submission.

For this task, it is assumed that you are still signed in on the P986130 – Work with Job Queues session that you used for the previous task.

  1. In the Batch Versions – Work with Batch Versions – Available Versions form, select the version you created in the previous exercise, and click OK to submit the job.
  2. Batch Versions - Work With Batch Versions - Available Versions Form
    Batch Versions - Work With Batch Versions - Available Versions Form
  3. On the Batch Versions – Version Prompting form, select Advanced from the Form menu.
  4. Batch Versions - Version Prompting Form
    Batch Versions - Version Prompting Form
  5. On the Batch Versions – Advanced Version Prompting form, select the following check boxes and click OK.
    • Override Job Queue
    • Submit Version Specifications Only
  6. Batch Versions - Advanced Version Prompting Form
    Batch Versions - Advanced Version Prompting Form
  7. Click Submit.
  8. Batch Versions - Version Prompting Form
    Batch Versions - Version Prompting Form
  9. Select the override queue from the list of all queues on all hosts that are part of the virtual host and click OK.
  10. Batch Versions - Virtual Hosts Job Queue Search & Select Form
    Batch Versions - Virtual Hosts Job Queue Search & Select Form

    Note that when you override the queue for a VBQ host, you are only picking a queue name, and not that server. The server part of the line is only used to ensure you see all possible available places the job could run.

    Your version has been submitted to the specified queue.

  11. On the Work with Batch Versions form, select Submitted Jobs from the Form menu.
  12. Form Menu
    Form Menu

    You can view your submitted job in the Batch Versions – Submitted Job Search form.

    Batch Versions - Submitted Job Search Form
    Batch Versions - Submitted Job Search Form

In this OBE, you learned how to use the P986130 – Work with Job Queues application to add job queues, use the Batch Versions application to add a custom version of R0008P, and use the advanced options in the Batch Versions application to submit your custom version to a non-default job queue.