Clear auto-generated RMAN command line jobs from schedule db on regular basis (80288)

Date: Feb 2008
Affected NV Version: ALL
OS Version:ALL
Plugin Version: Oracle/ Oracle RMAN
Applicaton Version:N/A

Description:
Jobs auto-generated by RMAN CLI command to backup db changes fill up schedule db as a new job is created every time

Symptoms:
Schedule db fills up quickly with lots of ‘RMAN controlled backup’ jobs

Cause:
Every time the RMAN CLI command to backup changes runs a new job is created.

In order to delete the RMAN generated jobs set up an NVDB backup job and create a postscript to run on completion of this job. Enter the following into a .bat file and save this in the /netvault/scripts dir:

“C:Program Files\Bakbone Software\Netvault\util\nvjobdelete.exe” -plugin “Oracle APM: *”

or “C:Program Files\Bakbone Software\Netvailt\util\nvjobdelete.exe” -jobtitle “RMAN controlled backup”

If the Netvault user is not admin enter the following in the .bat file above the command:

SET NETVAULTCLIACCOUNT=admin
SET NETVAILTCLIPASSWORD=


Then place this scriptname in the 'post-script' field in advanced options of the NVDB backup job.

As soon as the NVDB job completes, the RMAN generated jobs should be automatically deleted from the schedule db.