Tag Archive

Tag Archives for " PeopleSoft Process Scheduler "
1

PeopleTools 8.54: New Features in PeopleSoft Process Scheduler

In our past posts, we have already discussed about the changes in PeopleSoft Login Page, PeopleSoft Change Assistant & PeopleSoft Application Designer that were introduced with PeopleTools 8.54. In this post, lets quickly review the new features for PeopleSoft Process Scheduler. In almost all the organizations using PeopleSoft applications, PeopleSoft Process Scheduler is widely used […]

Continue reading
2

How to Find PeopleSoft Processes/PSJobs in a Recurrence

Do 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