7.15 Register Scheduler Job Events to Scheduler Queue

Oracle LSH uses Oracle Scheduler to perform job operations based on execution mode. If any unexpected events occur in the database that cause the Oracle Scheduler job to stop abruptly or fail, the associated job triggered in Oracle LSH needs to get marked as failed too. The following steps describe how to run the script to ensure this occurs:

1. Navigate to the $CDR_TOP/patch/115/sql directory on the Oracle LSH MT machine.
2. Log in to the 19c database as SYS user.
3. Run the cdrschprivs.sql script. You see the following message:
   This script grants the required privilege for scheduler event subscription. This script needs to be executed using SYS user. To continue, press Y and Return key. Press any other key to abort:
4. Enter Y.
   Here is a sample of the type of output you see:

   Apps user is registered for event queue subscription.
   Added LSH subscriber to scheduler event queue.
   Enabled LSH subscriber access to scheduler queue.
   Registered LSH subscriber to scheduler event queue.