RA_SBT_JOB

This view describes the defined SBT job templates.

Column Data Type NULL Description
TEMPLATE_KEY NUMBER NOT NULL The key of this SBT job template in the Recovery Appliance metadata database.
TEMPLATE_NAME VARCHAR2(128) NOT NULL The SBT job template name.
ATTRIBUTE_SET_NAME VARCHAR2(128) NOT NULL The SBT attribute set name.
LIB_NAME VARCHAR2(128) NOT NULL The SBT library name.
POLICY_NAME VARCHAR2(128)   The protection policy specifying databases whose backups the Recovery Appliance considers eligible for copying to tape.
DB_KEY NUMBER   The primary key of the protected database whose backups the Recovery Appliance considers eligible for copying to tape.
DB_UNIQUE_NAME VARCHAR2(30)   The unique name of the protected database whose backups the Recovery Appliance considers eligible for copying to tape.
BACKUP_TYPE VARCHAR2(16)   The types of backups to be copied to tape by this job: ALL, FULL, INCR, ARCH, or TAPE_RESERVE.
FROM_TAG VARCHAR2(32)   The backups with the specified tag to be copied to tape by this job.
PRIORITY NUMBER   The priority for scheduling this job.
COPIES NUMBER NOT NULL The number of copies to be created on tape.
LAST_SCHEDULE_TIME TIMESTAMP(6) WITH TIME ZONE   The last time at which this SBT job was scheduled to run.
WINDOW INTERVAL DAY(2) TO SECOND(6)   The time allotted for copy tasks to start for this job.
COMPRESSION_ALGORITHM VARCHAR2(6)  

The compression algorithm used by this job: NONE, BASIC, LOW, MEDIUM, HIGH, or OFF.

OFF indicates that compression was explicitly turned off for this job (the compression setting in the SBT job template was ignored).

Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.

TENANT_NAME VARCHAR2   The tenant name for this database in the Recovery Appliance.
TENANT_IDENTIFIER NUMBER   The customer tenant identifier for this database in the Recovery Appliance.