One of the most important part of PeopleSoft applcation is to run processes/reports to address the business requirements. All the jobs and processes are run on Process Scheduler but not every PeopleSoft user has access to run the processes. It is governed by the role of the user and security associated with the process/job. User who needs to […]
Continue readingDo you want to find out all processes and jobs running under a particular recurrence? Use this SQL below: SELECT process_job_name, description, recurname FROM ps_prcsrecur a, (SELECT p.prcsname AS Process_Job_name, p.descr AS Description, p.recurname AS recurname FROM ps_prcsdefn p UNION SELECT jp.prcsjobame AS Process_Job_name, (SELECT j.descr FROM ps_prcsdefn j WHERE j.prcsname = jp.prcsname) AS Description, jp.recurname AS recurname FROM ps_prcsjobdefn j, ps_prcsjobitem jp WHERE j.prcsjobname = jp.prcsjobname) b WHERE b.recurname = a.recurname AND a.recurname = :1 ORDER BY 1
Continue reading