RA_EM_SBT_JOB_TEMPLATE

This view lists defined SBT jobs and their statuses for Oracle Enterprise Manager.

Column	Data Type	NULL	Description
TEMPLATE_NAME	VARCHAR2(128)	NOT NULL	The name of the SBT job template.
FULL_TEMPLATE_NAME	VARCHAR2(128)	NOT NULL	The full name of the SBT job template.
POLICY_NAME	VARCHAR2(128)		The protection policy specifying the protected databases whose backups the Recovery Appliance considers eligible for copying.
DB_UNIQUE_NAME	VARCHAR2(512)		The unique name of the protected database whose backups the Recovery Appliance considers eligible for copying.
ATTRIBUTE_SET_NAME	VARCHAR2(128)	NOT NULL	The name of the SBT attribute set.
LIB_NAME	VARCHAR2(128)	NOT NULL	The name of the SBT library.
BACKUP_TYPE	VARCHAR2(16)		The types of backups to be copied to tape by this job: ALL, FULL, INCR, ARCH, or TAPE_RESERVE.
PRIORITY	NUMBER		The priority for scheduling this job.
COPIES	NUMBER	NOT NULL	The number of copies to be created on tape.
WINDOW	INTERVAL DAY(2) TO SECOND(6)		The time allotted for copy tasks to start for this job.
FROM_TAG	VARCHAR2(32)		The tag for the backup to be copied to tape by this job.
ERROR_TEXT	VARCHAR2(4000)		The error text for the task that failed.
ERROR_LAST_SEEN	TIMESTAMP(6) WITH TIME ZONE		The timestamp when the Recovery Appliance most recently detected the error.
EXECUTABLE	NUMBER		The number of tasks in an executable state.
RUNNING	NUMBER		The number of tasks that are running or retrying.
COMPLETED	NUMBER		The number of completed tasks.
COMPLETION_TIME	TIMESTAMP(6) WITH TIME ZONE		The time of the most recent completed task.
STATUS	VARCHAR2(5)		The status of the SBT library: READY, PAUSE, or ERROR.
BYTES	NUMBER		The number of bytes read or written so far.
COMPRESSION_ALGORITHM	VARCHAR2(6)		The compression algorithm used by this job: NONE, BASIC, LOW, MEDIUM, or HIGH. Note that this column is available only with Zero Data Loss Recovery Appliance software update 12.1.1.1.8 and later.