PeopleSoft Process Scheduler | PeopleSoft Tutorial - Part 2

Tag Archive

Tag Archives for " PeopleSoft Process Scheduler "

Error: You are not authorized to run the job XXXXX

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 reading
3

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
>