Title | Under | Posted on |
---|---|---|
Component interface Error: no rows exist for the specified keys | PeopleSoft Technical | 03/15/2019 - 3:54am |
ADD 24 months starting from current month.(peoplesoft) | PeopleSoft Functional | 07/29/2018 - 8:44pm |
TRC values dropdown | PeopleSoft Technical | 04/04/2018 - 12:54am |
how to find missing sequence in GRID and print the mising sequence number while saving through peoplecode | PeopleSoft Technical | 09/11/2017 - 4:49am |
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.
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog
Thats good to know.. lets know when you find out the name of the SQR.
Ashar, the sqr name is tblusage.sqr
Give back to the community and help it grow!
* Help with unanswered forum questions and issues
* Register or login to share your knowledge at your own blog