Recover Jobs that was inadvertently deleted

[Warren Tolentino]

I don't exactly remember but I seen it before from the yahoo group that there is a way to restore jobs that was deleted. By doing some dml statement on the oracle database. I think by update [table] set [column] = expression, .... where [expression]. If that can be recovered what will be the table and column involved that are needed to do the updates. This is for my reference and research.

Thank you,

Warren

[Tracy Donmoyer · Accepted solution]

Warning:  This is not sanctioned by Cisco/Tidal as it requires updating the database directly.

Some tables have a "dirty" column.  When an object is deleted, this column is set to 'X'.  To un-delete a job you need to clear the column.

update

jobmst

set jobmst_dirty = ''

where jobmst_name = ''

You will need to refresh your client to see the job.

Note: If you have "Automatic Daily History Cleanup" enabled, objects flagged for deletion will be deleted during nightly processing.

[Warren Tolentino]

Thank you this will help.