07-08-2015 01:14 PM
We have a few entries in OpsCenter "All Jobs" where the State is "deleted" or "unknown". They cannot be found in the NetBackup Master so they must stored somewhere in OpsCenter database. They are quite old & no longer needed. How to remove these entries?
Solved! Go to Solution.
07-13-2015 09:16 AM
You'll need to follow the process as described here to remove the entries https://www-secure.symantec.com/connect/forums/opscenter-deleting-master-servers-data
Having said that, support might have issues with you messing about in the DB.
Make sure you back it up before playing around.
07-10-2015 09:00 AM
Anyone? Anyone? Bueller?
:)
07-10-2015 10:29 PM
Please show an example.
07-13-2015 05:48 AM
JobID Master Type State Status Policy Client Start Elapsed End Size Files Complete
172402 Hostname Backup Deleted - - - - 00:00:00 - 0B 0 0%
172405 Hostname Backup Deleted - - - - 00:00:00 - 0B 0 0%
185271 Hostname Backup Unknown - - Hostname Jan 15 00:00:00 - 0B 0 0%
07-13-2015 09:16 AM
You'll need to follow the process as described here to remove the entries https://www-secure.symantec.com/connect/forums/opscenter-deleting-master-servers-data
Having said that, support might have issues with you messing about in the DB.
Make sure you back it up before playing around.
07-13-2015 12:09 PM
Yes, suspect it will be something like that.
Ours is running on Linux (forgot to mention that before). And what is the schema for jobs?
...
*edit*
found the Schema Guide - OC_Schema_Document_08May_7.6.pdf - and ran these commands.
select * from domain_Job where id=185271
delete from domain_Job where id=185271
commit
and after restart the offending entry is gone, thanks!
07-13-2015 09:22 PM
:)