Unlock Scheduled Process that Incrementally Loads SR Audit Data
Use the Unlock Scheduled Process that Incrementally Loads SR Audit Data process to remove the process lock created by the Execute Incremental Load of SR Audit Data for ReportingLoads Service Request Lifecycle Data scheduled process if there's is no instance of that scheduled process running, but you'reyou are unable to start a new instance.
Removes the process lock created by the Loads Service Request Lifecycle Data process when that process fails to remove its lock automatically.
When to Use
The process should only be run if the scheduled Loads Service Request Lifecycle Data process is unable to start and no other instance of the process is currently running. It should not be run under any other circumstance.
It should only be necessary to run this process if the Loads Service Request Lifecycle Data process is aborted (either manually or through some unexpected system event, such as a server crash) and doesn’t get a chance to clean up before exiting.Privileges Required
Verify that you have the following roles or privilege:
-
To administer the job, one of the following roles are required with delete, execute, read and update:
-
ORA_SVC_HELPDESK_ADMINISTRATION
-
ORA_SVC_SR_ADMINISTRATOR
-
-
To schedule the job, the following privilege is required:
-
SVC_SCHEDULE_SERVICE_JOBS_PRIV
-
Before You Start
Review the following before scheduling this on demand process:
-
Don't run this process if the Loads Service Request Lifecycle Data process is currently running.
-
Execution Time:
-
The execution time is less than 2 seconds.
-
-
Compatibility:
-
No other processes are triggered when this job runs.
-
No potential impact on the server performance while this job is running.
-
There can be only one instance of the job running at any one time.
-
There are no issues with business processes executing in parallel with this job.
-
This scheduled process is incompatible with itself; therefore, only one instance of the job should be running at any particular time.
-
Parameters
None.
Troubleshooting Information
Use this information to troubleshoot the scheduled process.
-
Notification of job completion would be using the standard scheduled process job notification system.
-
If the scheduled job doesn't run successfully, it should be submitted again.
-
This scheduled process is idempotent, and no cleanup activity is required if the job fails.
-
To verify that this scheduled process has been successful, schedule the Loads Service Request Lifecycle Data process and confirm it is successfully able to load data.