DailyJobActivity Syntax - Teradata VantageCloud Lake

Lake - Monitor Resources and Performance
Deployment
VantageCloud
Edition
Lake
Product
Teradata VantageCloud Lake
Release Number
Published
February 2025
ft:locale
en-US
ft:lastEdition
2025-11-21
dita:mapPath
wyu1683671641248.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
wyu1683671641248

API Definition

REPLACE PROCEDURE TDStats.DailyJobActivity( 
    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_DailyJobActivity 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.
AutoDbJobName VARCHAR(20) Name of AutoDb Service job.
JobSchedule VARCHAR(20) Scheduled wake-up interval.
Completed INTEGER Number of completed job runs.
InProgress INTEGER Number of jobs currently in progress.
Skipped INTEGER Number of job scheduled runs skipped due to system conditions, e.g., another run of the same job was still in progress.
Failed INTEGER Number of job runs with errors.
Aborted INTEGER Number of aborted job runs.
WithWarning INTEGER Number of job runs that completed with warnings.
MostRecentError TIMESTAMP Most recent job run with errors.
ErrorCodes VARCHAR(40) Error codes reported by job.