Database Background Jobs are operations which are not executed immediately when the user invokes the operation. This is common for operations that will take some time to execute. By executing an operation as a background job, the user can continue their work without having to wait for the operation to finish.
The overview page for Background Jobs is located under Solution Manager/Background Processing/Background Jobs in the navigator. This will show a list of all Background Jobs.
The jobs may have these different states:
Jobs in state Posted can be modified by changing queue and parameters and may also be removed. Once the Background Job is initialed by the server it will change state to Executing..
See Execution and Status section on the detail page for more information on the Background Job while it’s executing. This information is both shown in the overview and detail page. A Background Job that is being executed can be stopped. The Background Job will then change to Error state
A Background Job for a Business Report that has been configured to be
rendered by the BR Execution Server. See Execution and Status section on the
detail page for more information on the Background Job while it’s executing.
This information is both shown in the overview and detail page. A Background
Job that is being executed can be stopped. The Background Job will then
change to Error state.
Background Jobs in state Ready cannot be modified. The Background Job can be manually removed, or it will be removed by the Foundation1 Light Cleanup.
See Execution and Status section on the detail page for more information
about the warnings for the Background Job. Background Jobs in state
Warning cannot be modified as it’s considered to be finished. The Background
Job can be manually removed, or it will be removed by the Foundation1 Light
Cleanup.
See the Error Information section for more details about why the Background Job stopped. Background Jobs in state Error can be modified by changing queue and parameters and may also be removed. It is possible to re-execute the Background Job.
The Foundation1 Light Cleanup process will remove Background Jobs in state
Ready, Warning and Error unless they are marked to be excluded from cleanup.
Each state has their own time limit for how long they should be kept before
cleaned. This is set by the system parameters. To change the cleanup interval,
change the interval for the "Cleanup age
limit in days for completed background jobs", "Cleanup
age limit in days for background jobs with warning" and "Cleanup
age limit in days for background jobs with errors". The only way to remove a
job marked to be excluded from cleanup, is to remove it manually.
Note: The Background Jobs form does not show Oracle DBMS_SCHEDULER jobs like IFS/Info Services. Only deferred jobs created by using system service Transaction_SYS or jobs created by scheduled tasks are shown.
For Background Jobs that takes a long time to execute, the job may also update
the Progress Information. For instance, when several objects are processed one by one by the
Background Job, it often updates the progress information about what object that
is currently being processed, how many objects that are to be processed in total
(Total Work) and how many objects
that have been processed so far (So Far).