Once created, a scheduled background process displays on the BG Processes tab under the 'Scheduled Processes' folder, and within a folder that indicates the state:
-
Queued Processes are waiting for the next scheduled run.
-
Active Processes are currently running.
-
Completed with Errors Processes are ended and at least some of the process succeeded. This state is available for a limited number of processes.
-
Ended Processes have been aborted or the schedule is completed.
For details on the states of a background process, refer to the BGP States and Quarantine Status topic.
For details on creating a scheduled background process, refer to the Scheduling a BGP topic.
A scheduled process begins in the Queues Processes folder until the scheduled time arrives. Then the process displays in the Active Processes folder until it is completed. The same process again goes into the Queued Processes folder until the next scheduled time. The process is moved to Ended Processes folder after successful completion of the schedule or if it is aborted while not running. If a user aborts the process before the schedule is complete, or if there is an error in the BGP, the process moves to the Active Processes folder with red text indicating an execution error.
Important: Consider the time zone of the application server compared to that of the workbench (the client) where the schedule is created or viewed. When scheduling a job, the local time zone is displayed in the workbench, but the time zone of the server is used to run the background process. Although displayed, the time zone of the client is not included in the instruction to the server to run the job. This can cause confusion about when the job will run since the scheduled time is not automatically converted to accommodate potential differences in time zones.
The Background Process editor tab displays the following data about the selected export:
-
Started by shows the user who scheduled the export process.
-
ID shows the background process ID.
-
Description is the text added in the 'Scheduled Process Name' field when the scheduled export was created.
-
Schedule defines the frequency that the export is scheduled to run.
-
Execution Server shows the name of the database server running the export.
-
Status can be waiting, active, or aborted, depending on the current situation.
-
Created shows the day, date, and time that the scheduled export was created.
-
Started is the day, date, and time that the scheduled export first ran.
-
# of warnings is the number of warning messages included in the execution report.
-
# of errors is the number of error messages included in the execution report.
-
Next Run is the day, date, and time that the export will run again.
Note: Administrators can edit the 'Started by' field. This helps to update users that no longer exist for existing scheduled processes instead of manually recreating them or deleting them.