The following example reports job activity for the past week.
CALL TDSTATS.DAILYJOBACTIVITY('{"BeginDate":"CURRENT_DATE - 7","EndDate":"CURRENT_DATE"}');
Result:
| ReportDate | AutoDbJobName | JobSchedule | Completed | InProgress | Skipped | Failed | Aborted | WithWarning | MostRecentError | ErrorCodes |
|---|---|---|---|---|---|---|---|---|---|---|
| 2024/02/04 | stats_apply | Every 1 hour | 43 | 0 | 19 | 0 | 0 | 0 | ||
| 2024/02/04 | stats_automate | Every 1 hour | 62 | 1 | 0 | 0 | 0 | 0 | ||
| 2024/02/04 | stats_inline | Every 5 minutes | 125 | 0 | 0 | 0 | 4 | 0 | ||
| 2024/02/04 | stats_missing | Every 2 hours | 62 | 1 | 0 | 0 | 0 | 0 | ||
| 2024/02/04 | stats_stale | Every 6 hours | 125 | 0 | 0 | 0 | 0 | 0 |