Oracle Cloud SCHEDULING Secrets You Need to Know
Oracle Cloud - Schedule Processes Guide
Which Roles Are Required To Access Scheduled Processes
You need to have one of the following:
Employee - PER_EMPLOYEE_ABSTRACT
Contingent Worker - PER_CONTINGENT_WORKER_ABSTRACT
How to View and extract ALL Scheduled Processes??
SELECT distinct erp.value Report_Path,
erh.SUBMITTER,
erh.EXECUTABLE_STATUS,
to_char(PROCESSSTART,'MM/DD/YYYY') PROCESSSTART,
to_char(PROCESSEND,'MM/DD/YYYY') PROCESSEND,
erh.REQUESTID,
(CASE
WHEN state = 1 THEN 'Wait'
WHEN state = 2 THEN 'Ready'
WHEN state = 3 THEN 'Running'
WHEN state = 4 THEN 'Completed'
WHEN state = 9 THEN 'Cancelled'
WHEN state = 10 THEN 'Error'
WHEN state = 12 THEN 'Succeeded'
WHEN state = 13 THEN 'Paused'
ELSE TO_CHAR (state)
END)
request_state
FROM fusion.ess_request_history erh, fusion.ess_request_property erp
WHERE 1 = 1
AND erh.requestid = erp.requestid
AND erp.name = 'report_url'
and state in ( 1,2,3 )
ORDER BY erh.requestid DESC
Blocked The job request is blocked by one or more incompatible job requests.
Canceled The job request was canceled.
Canceling The job request has been canceled and is awaiting acknowledgement.
Completed The job request has completed and postprocessing has commenced.
Error The job request has run and resulted in an error.
Error Auto-Retry The job request has run, resulted in an error, and is eligible for automatic retry.
Error Manual Recovery The job request requires manual intervention to be retried or transition to a terminal state.
Expired The job request expired before it could be processed.
Finished The job request, and all child job requests, have finished.
Hold The job request has been explicitly held.
Paused The job request paused for subrequest completion.
Pending Validation The job request has been submitted but has not been validated.
Ready The job request has been dispatched and is awaiting processing.
Running The job request is running.
Schedule Ended The last submission in a schedule has happened for a process that's either a process set or a process that causes other processes to automatically run.
Succeeded The job request has run and completed successfully.
Validation Failed The job request has been submitted, but validation has failed.
Wait The job request is awaiting dispatch.
Warning The job request has run and resulted in a warning.
Overview of Managing Job Definitions and Job Sets
1. Scheduled processes are used based on jobs to process data and to provide report output.
2. Each job requires a job definition
3. Job Definitions: Contain the metadata about the job and the options available to users
4. List of Values Sources: Determine where a list of values for the parameters in a job definition comes from and what the specific values are
5. Job Sets: Collections of several jobs in a single process set that the users submit instead of running separate jobs.
Benefits of Job sets:
• Job sets help customize your needs where the seeded functionality is not there
• Lessen user intervention
• Enables Job dependency • Enables parallel Job execution