2007 Dec 13 6:20 AM
Hi,
Does anyone know how can I find out who deleted a job?
Does the system record this anywhere?
Thanks
2007 Dec 13 6:23 AM
Hi,
check the tables : CDHDR and CDPOS.
use chngid = 'D'.
Reward points, if helpful,
Sandeep Kaushik
2007 Dec 13 6:38 AM
Hi,
Thanks for the quick reply.
These tables do not contain data on jobs, as far as i know.
It did not solve my problem.
2007 Dec 13 6:42 AM
Hi,
You can find the details of the job in table TBTCO there is a field DELETE JOB which will be set to 'X' and there is also a field which says last changed by.
This will let you know who deleted the job.
Regards,
Omkar.
2007 Dec 13 6:55 AM
Hi,
Are you sure you gave me the correct table name?
This table is for jobs that ran in the past.
If a job was not deleted while it was active it will not a record in this table.
Thanks
2007 Dec 13 7:08 AM
yes...the table is correct.
you can find last changed by(LASTCHNAME) when deletejob(DELANFREP) is 'x'.
2007 Dec 13 7:16 AM
Hi,
The job was deleted but the deletion flag is not marked in this table.
The job was probably deleted after the last run was recorded into this table
Thanks