Understand your Scheduled Jobs dashboard
Visit scheduler dashboard to learn about key health metrics and insights of scheduled jobs.
Navigate to .
The following cards show up on the dashboard
| Field | Description |
|---|---|
|
Stuck Jobs |
The scheduled jobs that are pinned to a non-existent node show up here. If a scheduled job is assigned to run on a non-existent node and is a parent job that doesn't have Startup as the
Trigger Type, it is classified under Stuck Jobs. The System ID column states the node that the job was assigned to run. One of the reasons of a job being classified as
Stuck Jobs is if an instance was cloned from another instance and now there are jobs pinned to run on the old instance's nodes. You can take the following actions on the stuck jobs:
|
|
Permanent Error Jobs |
The scheduled jobs which have a State of Permanent Error show up here. If you have upgraded from a pre-Utah version to a more recent version, a fix
script is executed and it sets the scheduled jobs to Permanent Error state if the job was a parent job or a standalone job and picked up to run on a specific node that no longer exists. You can also
set the job state to Permanent Error manually. You can take the following actions on the permanent error jobs:
|
| Pending Jobs | Jobs that are to be executed soon. |
| Running Jobs | Jobs that are actively running. |
| Jobs Classification (optional) | Optional way to group certain jobs based on filter conditions to collect job completion history by the defined group/classification. You can set up these classifications in the Job Classification Rules table. The default classification is TriggerType.JobName. |
|
Total Execution Count |
Graphical representation of the total number of scheduled job executions on your instance over a period of time. The default time period is last 24 hours. You can view the data only from last 7
days. The data originate from the sys_scheduler_job_history table.
Note: When you click on an execution count in the graph, the Scheduled Job History list shows up. The list of jobs have been grouped using Jobs
Classification concept with Trigger Type as either Run Once or Recurring. |
| Average Lateness | Graphical representation of the average lateness in milliseconds of all scheduled jobs on your instance over a period of time. The default time period is last 24 hours. You can view the data only from last 7 days. The
data originates from the sys_scheduler_job_history table. Note: When you click on a lateness average data in the graph, the Scheduled Job History list shows up. The list of jobs have been grouped using Jobs Classification
concept with Trigger Type as either Run Once or Recurring. |
|
Scheduled Job Trends |
List of completed jobs grouped by Job Classification concept. The default time period is last 24 hours. You can view the data only from last 7 days. The data originate from the sys_scheduler_job_history table. |
Note:
For both Stuck Jobs and Permanent Error Jobs tiles, the data and columns originate from the sys_trigger table. Both the tiles are used to cleanup jobs and keep
the scheduled jobs in a positive state. Select the required tile to see the list view of the jobs. The Lateness column on both the lists refers to how late the job is based on the time it was supposed to run.
If Next Action is in the past, the lateness is calculated as the current time minus the next action time. For example, if the job was scheduled to run two minutes ago, then lateness is two minutes. If the job
is scheduled to run in the future, then the lateness is 0.
Scheduled Job Trends
This table provides details on the history of completed jobs by classifications. Default view provides the data for last 24 hours.
| Field | Description |
|---|---|
| Job Classification | Provides a way of grouping similar type of jobs based on job name, trigger type (recurring, run once, etc.). |
|
Priority |
Priority at which the jobs are processed.
Note: The lower the number, the higher is the priority. For example, priority of 10 is higher than 100. |
| Execution Count | Number of times the job has been executed within a timeframe. |
| Average Processing Time(s) | Average time needed to process the jobs. |
| Total Processing Time(s) | Total time needed to process the jobs. |