adm_report_job_status_v
Job monitoring view showing job execution status, error tracking, recent activity, and log summaries for system administration and troubleshooting.
Overview
Section titled “Overview”Category: Jobs - Background job monitoring and administration
Use Cases
Section titled “Use Cases”- System administration
- Job monitoring
- Error tracking
- Performance analysis
Columns
Section titled “Columns”The view contains 9 columns providing comprehensive information:
| Column Name | Description |
|---|---|
job_id | Unique identifier of the background job. |
job_last_run_date | Timestamp of the last successful job execution. |
job_last_error_date | Timestamp of the last error encountered by the job. |
days_since_last_run | Number of days since the job was last successfully executed. |
days_since_last_error | Number of days since the last error occurred (null if no errors). |
log_entries_last_24h | Count of log entries generated by this job in the last 24 hours. |
error_entries_last_week | Count of error-level log entries generated by this job in the last week. |
latest_log_message | Most recent log message from this job. |
latest_log_level | Log level of the most recent log entry: ERROR, INFO, or TRACE. |
Description: Comprehensive job monitoring view showing job execution status, error tracking, recent activity, and log summaries for system administration and troubleshooting.
Key Features
Section titled “Key Features”- Job execution status
- Error tracking
- Recent activity summaries
- Log analysis