Schedule a Concurrent Program to run every week day and Working Hours

Oracle Provided much flexibility in scheduling the Concurrent Program Requests, but still at times some of the customers require their Programs to run only on Certain Hours and Certain days.
Consider a program that should be run only on Weekdays and only on Working Hours, herein are the steps to run the Program on Working hours on Weekdays:

1. Define Workshift with the Required Times and Days
    Sysadmin -> Concurrent -> Manager -> Workshifts
2. Define a Concurrent Manager and associate a Program for a Particular Manager
    Sysadmin -> Concurrent -> Manager -> Define
3. Associate the Specialization Rules with the program to be associated to the Concurrent Manager
    Sysadmin -> Concurrent -> Manager -> Define -> Specialization Rules
    Include the Program.

4. Now you can schedule the Program the while submitting the Concurrent Request and the associated Concurrent Manager will work only for the associated Work Shift defined. However if the associated Manager is not available then any Standard manager that exists in the Oracle instance will try to run the Job. To stop them from running the Job it will be necessary to add an Exclusion Rule to those Standard Managers to explicitly tell them not to run the Jobs. However in the exclusion hours of the Work Shifts the Programs Phase/status will be of Inactive/No Manager.

Print This Post