Skip to main content
Top

How do I use the Job Scheduler Expert with Nastel XRay?

The Nastel Job Scheduler Expert is a shared Nastel AutoPilot Service that is used in the background by Nastel XRay to schedule changes to the environment. Below are the requirements and installation steps to utilize the Job Scheduler Expert.

Prerequisites

Confirm that the following requirements are met before installing the Job Scheduler Expert:

  • Job Scheduler Expert 0.1.3 or higher
  • Nastel XRay 1.3 or higher
  • Service Update AP60_SU31.x.pkg or higher
  • Java 1.8 or higher
  • Nastel XRay assumes there is only a single instance of the Job Scheduler Expert, which uses Kafka for communications (the Nastel XRay install will configure this automatically). If both Nastel Navigator and XRay are installed, just one Job Scheduler Expert will need to be configured.
  • One of the following supported configurations:
    Option 1:  Utilize multiple schedulers with a common corporate database. These scheduler database tables cannot be shared, but allow for a unique prefix for each of the scheduler tables (see configuration below). A single schema could support multiple scheduler instances.
    mceclip0.png
    Option 2:      Using a local dedicated database for scheduler. This scheduler database requires minimal maintenance which makes it a good candidate for a local instance. The WGS DB could be shared or separate in this model. In this case, default prefix is sufficient for scheduler tables.
    mceclip1.png

Installation steps

  1. Install the package, JOB_SCHEDULER-0.1xx.pkg. The scheduler can be found in the same media or website from where you obtained the Nastel XRay experts.
  2. Locate and run the SQL files that will create the scheduler tables for your specific database. The SQL files are located in the following location: 
    AutoPilotM6/scheduler/config/db/
    AutoPilotM6/scheduler/config/db/upgrades (if upgrading from earlier version)
    The SQL file names are as follows. Run them from the command client or database Admin tool. 
    ap-sched-<db>.sql
    upgrade-0.x.xx-sched-<db>.sql
  3. Create the quartz tables by running the following SQL file: 
    AutoPilotM6/scheduler/config/db/quartz_<db>.sql
    If you plan to use a prefixed version (option 1 above), change QRTZ_ to your prefix. For simplicity, we recommend the WGS name as the prefix. For example, QRTZ_FIRED_TRIGGERS would become WGSPROD_FIRED_TRIGGERS.

  4. Open the Job_Scheduler Properties screen by right clicking on Job_Scheduler and select Properties from the menu.
    mceclip2.png

  5. Configure the Database tab to the database where you ran the scripts and click Deploy if this is a new installation or Apply if you are editing an existing installation. 
    mceclip0.png
    In the DB Table Prefix field specify the prefix used when creating the tables in step 3. This can be an environment variable such as {WGS}.

  6. Restart the CEP server.
    mceclip4.png
  7. Verify that the scheduler service starts.
  8. The Job Scheduler Expert is now ready to be utilized. 

Related articles