API Definition
REPLACE PROCEDURE TDStats.DailyJobErrors(
IN jIn JSON(2000) CHARACTER SET UNICODE)
DYNAMIC RESULT SETS 1
JSON Input Keys
| JSON Key |
Data Type |
Description |
|---|
| BeginDate |
DATE |
Starting date for job activity. |
| EndDate |
DATE |
Ending date for job activity. |
| ReturnTable |
BOOLEAN |
When true, results will be stored in a session level temporary table named AutoDBA_DailyJobErrors rather than being returned as a dynamic result. Default is false.
|
Dynamic SQL Result Columns
| Column Name |
Data Type |
Description |
|---|
| ReportDate |
DATE |
Date for reported job activity that encountered errors. |
| AutoDbJobName |
VARCHAR(25) |
Name of AutoDb service job. |
| ErrorCode |
INTEGER |
Error code. |
| ErrorText |
VARCHAR(1024) |
Error text. |