to find out the jobs - means Application engines?

If it is application engines we can sort out easily. We have a delivered record which will hold all the sql definitions resides in a app engine. I think PSAESTMTDEFN is the record. this rec will have AE_APPLID - Application engine name, SQLID - Sqls. you can query the sqltextdefn rec to find out what are the sqls using your rec. Then u can query this PSAESTMTDEFN record to find out the job.

I think it is going to be a tough job. What if developer had used the record in PeopleCode? and how about SQRs? There are different possibilities of using the record in jobs. Please be specific in your question.

There is a delivered SQR that you can use to gets records and how they are used in AEs, SQRs, and Cobol. I can't remember the sqr name right at this moment but i've used it before. It outputs tables used in the programs and the action taken on them, like insert, update, delete and so on.

Thats good to know.. lets know when you find out the name of the SQR.

Ashar, the sqr name is tblusage.sqr