HP Neoview Release 2.5 Software - Manual (Page 21)

STOP_JOB_BACKUP Stored Procedure
The STOP_JOB_BACKUP stored procedure checks the status of the currently executing backup
operation, and then stops it on all segments. STOP_JOB_BACKUP can be used when a backup
job is in automatic or manual initiation mode.
NOTE: It can take several minutes to completely stop an executing backup job. Use the
STATUS_JOB_BACKUP SPJ to confirm that the backup job has stopped. See
“STATUS_JOB_BACKUP Stored Procedure” (page 20) .
This SPJ is available for use only by super-group users, HP support, and users belonging to
ROLE.DBA.
Syntax
CALL NEO.HP_SP.STOP_JOB_BACKUP(?)
Parameters
This procedure has no input parameters.
Output and Error Conditions
The status returned is one of these values:
• STOP_OPERATION_INITIATED_SUCCESSFULLY
• NO_BACKUP_IN_PROGRESS
• COULD_NOT_INITIATE_STOP_OPERATION, reason
NCI Example
SQL>call neo.hp_sp.stop_job_backup(?);
STATUS
--------------------------------------
STOP_OPERATION_INITIATED_SUCCESSFULLY
--- 0 row(s) selected.
--- SQL operation complete.
STOP_JOB_BACKUP Stored Procedure 21