HP Neoview Release 2.5 Software - Manual (Page 20)

STATUS_JOB_BACKUP Stored Procedure
The STATUS_JOB_BACKUP stored procedure displays the status of the last backup operation
or the currently executing backup operation. STATUS_JOB_BACKUP can be used when a backup
job is in automatic or manual initiation mode. This stored procedure is available for use only by
super-group users, HP support, and users belonging to ROLE.DBA.
Syntax
CALL NEO.HP_SP.STATUS_JOB_BACKUP(?)
Parameters
This procedure has no input parameters.
Output and Error Conditions
The status returned is one of these values:
• IN_PROGRESS, start-timestamps
• STOPPED, start-timestamps, end-timestamps
• FAILED, start-timestamps, end-timestamps, reason
• COMPLETED_SUCCESSFULLY start-timestamps, end-timestamps,
RPO-timestamps
• COMPLETED_SUCCESSFULLY_ WITH_WARNINGS start-timestamps,
end-timestamps, RPO-timestamps, reason
• COULD_NOT_CHECK_STATUS, reason
NOTE: The RPO (recovery point objective) time is the specific point in time to which you can
recover using the specified backup job. The server-based RMDR software automatically calculates
and displays the RPO timestamp for the backup job.
NCI Example
SQL>call neo.hp_sp.status_job_backup(?);
STATUS
----------------------------------------------------------------
COMPLETED_SUCCESSFULLY
ATTRIBUTE_NAME ATTRIBUTE_VALUE
----------------------------- --------------------
JOB_START_UTC_TS 18-AUG-2010 17:46:34
JOB_START_LCT_TS 18-AUG-2010 10:46:34
JOB_END_UTC_TS 18-AUG-2010 19:42:42
JOB_END_LCT_TS 18-AUG-2010 12:42:42
JOB_RECOVERY_POINT_OBJ_UTC_TS 18-AUG-2010 18:54:33
JOB_RECOVERY_POINT_OBJ_LCT_TS 18-AUG-2010 11:54:33
--- 6 row(s) selected.
--- SQL operation complete.
20 Stored Procedures for Managing Backup Jobs