Stop_job_backup stored procedure, Syntax, Parameters – HP Neoview Release 2.5 Software User Manual

Page 21: Output and error conditions, Nci example

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