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.