SYSBACKUPJOBS System Table

The SYSBACKUPJOBS table maintains information about all backup jobs that have been created for the database.

SYSBACKUPJOBS system table
Column Name Type Length Nullable Contents
JOB_ID BIGINT 19 NO The ID of this backup job.
FILESYSTEM VARCHAR 4000 NO The backup destination directory.
TYPE VARCHAR 32 NO The backup type; possible values are: incremental or full.
HOUR_OF_DAY INTEGER 10 NO The regularly scheduled start time (in GMT hours) of the backup job if it is a daily backup.
BEGIN_TIMESTAMP TIMESTAMP 29 NO When this job was submitted.