The following example reports job errors for the past week.
CALL TDSTATS.DAILYJOBERRORS('{"BeginDate":"CURRENT_DATE - 7","EndDate":"CURRENT_DATE"}');
Result:
| ReportDate | AutoDbJobName | ErrorCode | ErrorText |
|---|---|---|---|
| 2024/05/13 | stats_automate | -1 | ? |
| 2024/06/11 | stats_inline | 3809 | 1 Column 'DatabaseName' is ambiguous. |
| 2024/07/24 | stats_stale | 6881 | 2 thread(s) encountered the following DBS errors: 3706. Please check query logs. |