Can We Recover deleted job

[via]

Hi All,
If we accidently delete a job from the datastage repository in designer, Can we recover that deleted job? Where(exact path) will be the deleted jobs get stored? I guess deleted files and jobs will be in a specific folder on the datastage server!
Can any one clarify this!
Thanks..

[chulett]

No, they are not stored in anything like a 'Recycle Bin' where you can simply click 'Undelete' and get it back. They are gone. You would need to recover it from your backups... you are backing things up, yes?

[via]

Yes Craig, we are backing up.But i am guessing is there any folder on server where deleted jobs will be stored..

Thanks.

[DSguru2B]

No such thing. Recover the job from backup.

[kcbland]

Job designs are rows in a table. Delete a job = delete rows. There's no "undelete", as the design information is physically removed.

[via]

Thanks all.
But as Kcbland said job designs are rows in table.If we delete a row from a table, the activity will be logged.So is it the same as if we delete job, its logged? If so, where can we check those logs?

Thanks..

[mctny]

Thanks all.
...the activity will be logged. ......
..

No the activity is not logged. As the Gurus said, the only option you had is to bring the job from the backup (or the second option would be to recreate the job )

[via]

Thank you all. I got it.

[chulett]

The fact that a delete was performed is logged in the DS_AUDIT table. But nothing else is logged and none of the deleted information is saved out there.

[via]

Thanks Craig for clarification..What are the columns in DS_AUDIT table?May be: user who deleted, deleted jobname, time of deletion like those info..is that right....

Thanks

[ray.wurlod]

From your Administrator client Command window:

Code: Select all

LIST.DICT DS_AUDIT

to learn the column names.

Code: Select all

SELECT CLASS, INSTANCE, PREVDTD, PREVDELETOR FROM DS_AUDIT WHERE PREVDTD > '';

to identify what was deleted when and by whom. Constrain on CLASS = '2' to limit the report to jobs.