1. Understanding Scheduled Processes
  2. Pause Service Business Intelligence Automatically Submitted Processes

Pause Service Business Intelligence Automatically Submitted Processes

Use this process to pause the processing of data by the automatically submitted process Execute Service Business Intelligence Automatically Submitted Processes.

When to Use

The latter process runs the following four processes:

  • Execute Incremental Load of SR Audit Data for Reporting
  • Aggregate Service Requests
  • Execute Incremental Load of Cross-Channel Interaction Data for Reporting
  • Execute Incremental Load of HCM Person Mapping Data for Reporting

While these processes were replaced by four manually submitted processes in 24B, customers can choose to continue to use the automatically submitted process rather than the manually submitted processes. If the customer wants to pause processing of data by the automatically submitted process; for example, to perform a mass import or update, then this new process allows them to do that.

To resume processing of data, use the Resume Service Business Intelligence Automatically Submitted Processes process.

What this On-Demand Process Does

Creates an internal marker than informs the automatically submitted process that it should not process any data when it runs (it is automatically scheduled to run hourly).

When to Use

The process can be used to either temporarily or permanently pause the processing of data by the Execute Service Business Intelligence Automatically Submitted Processes process. The customer could run this process if they are planning to perform a mass update or import of data that may be impacted by the automatically submitted process. They could also run this process if they are planning to use the following four manually submitted processes added in 24B.

  • Loads Service Request Lifecycle Data
  • Loads Service Request and Interaction Data
  • Loads Interaction Cross Channel Data
  • Loads HCM Person Mapping Data

The process should only be run as needed.

Privileges Required

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:

  • You can run this process while the Execute Service Business Intelligence Automatically Submitted Processes is currently running, but it will only take effect on the next run of that process.

  • 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 should only 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 job doesn't run successfully, it can be submitted again.
  • This process is idempotent, and no cleanup activity is required if the job fails.
  • To verify that this process has been successful, run it again and verify the results in the execution log (the log will indicate that the automatically scheduled process is already paused).