HP Neoview Release 2.5 Software - Manual (Page 19)

3 Stored Procedures for Managing Backup Jobs
In Neoview Release 2.5, you can start, stop, and get information about a backup operation by
using these stored procedures for Java (SPJs):
• “START_JOB_BACKUP Stored Procedure” (page 19)
• “STATUS_JOB_BACKUP Stored Procedure” (page 20)
• “STOP_JOB_BACKUP Stored Procedure” (page 21)
START_JOB_BACKUP Stored Procedure
The START_JOB_BACKUP stored procedure:
• Determines the status of the currently executing backup operation.
• Ensures that the Neoview full backup job is in “manual-initiation” mode.
• Starts the overall backup operation manually for all segments.
NOTE: Do not use this stored procedure if your backup jobs are currently configured to run
automatically. If you want to start a backup operation on-demand, you must request that HP
support change the initiation mode. Changing the initiation mode is an HP support function.
After HP support changes the initiation mode from automatic to manual initiation, you will be
able to use the START_JOB_BACKUP stored procedure.
This SPJ is available for use only by super-group users, HP support, and users belonging to
ROLE.DBA.
Syntax
CALL NEO.HP_SP.START_JOB_BACKUP(?)
Parameters
This procedure has no input parameters.
Output and Error Conditions
The START_JOB_BACKUP output can be one of these conditions:
• STARTED_SUCCESSFULLY
• COULD_NOT_START, reason
• BACKUP_ALREADY_IN_PROGRESS, start-timestamps (the timestamps are expressed
in local civil time (LCT) and universal coordinated time (UCT))
NOTE: It can take up to 10 seconds for the output to be displayed.
NCI Example
SQL>call neo.hp_sp.start_job_backup(?);
STATUS
---------------------------------------
STARTED_SUCCESSFULLY
--- 0 row(s) selected.
--- SQL operation complete.
START_JOB_BACKUP Stored Procedure 19