Scheduled BGP Properties

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. Once the process has been scheduled, the Schedule field will always show the server time zone regardless of which time zone the user who scheduled the process is in. And, the Next Run field will show the local time zone.

The Background Process editor tab displays the following data about the selected export:

  • Started by shows the user who scheduled the background process.

    To change the user for a scheduled or queued BGP, add the 'Manage Background Process Execution' Setup Action privilege to the relevant user group. This privilege enables the selector button. As required, the user on an existing scheduled processes can be changed instead of manually recreating or deleting the scheduled 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 based on the server time zone.

  • 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 local day, date, and time that the export will run again.