On The Peoplesoft Road : Peoplesoft Process Scheduler

In order to create the Process Scheduler, you have to connect to your application within the "super user" PS (or the default one for your application).

1. In Peopletools/Process Scheduler/Report Nodes menu, add a report node definition :

2. In Peopletools/Process Scheduler/Servers, look for the Server Definition which you want to use (here PSUNX) :

Go on the Distribution tab, and change the report node as the one you created at the step 1 :3. In Peopletools/Security/User Profile, look for the PS user which you want to use to run the Process Scheduler server (here PS), andd add the role ReportDistAdmin :
4. Create the new Process Scheduler
[hrms9@orion:/apps/psoft/hrms9/appserv]$ ./psadmin

PSADMIN -- Tools Release: 8.49.08
Copyright (c) 1988, 2003, Oracle. All rights reserved.

--------------------------------
PeopleSoft Server Administration
--------------------------------


1) Application Server
2) Process Scheduler
3) Search Server
q) Quit


Command to execute (1-3, q): 2


-------------------------------------------
PeopleSoft Process Scheduler Administration
-------------------------------------------

1) Start a Process Scheduler Server
2) Stop a Process Scheduler Server
3) Configure a Process Scheduler Server
4) Create a Process Scheduler Server Configuration
5) Delete a Process Scheduler Server Configuration
6) Edit a Process Scheduler Configuration File
7) Import an existing Process Scheduler Configuration
8) Show Status of a Process Scheduler Server
9) Kill a Process Scheduler Server
10) Clean IPC resources of a Process Scheduler Domain

q) Quit

Command to execute (1-10, q) : 4


Please enter name of Database that server will access :DMOHRMS9

Process Scheduler Configuration templates:

1) unix

Selecting the only Process Scheduler Configuration template available...

Creating Process Scheduler Server for Database DMOHRMS9...
Copying Process Scheduler Server configuration file(s)...
Stripping Annotations...
Process Scheduler Server configuration created.

Would you like to configure this Process Scheduler Server now? (y/n) [y] :

5. Configure the Process Scheduler and load the new config
------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: DMOHRMS9
------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr : Yes 5) DBNAME :[DMOHRMS9]
2) App Eng Server : Yes 6) DBTYPE :[ORACLE]
7) PrcsServer :[PSUNX]
8) UserId :[QEDMO]
9) UserPswd :[QEDMO]
10) ConnectID :[people]
11) ConnectPswd:[peop1e]
12) ServerName :[]
Actions 13) Log/Output Dir:[%PS_SERVDIR%/log_output]
========= 14) SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
3) Load config as shown 15) AddToPATH :[%PS_HOME%/cblbin]
4) Custom configuration
h) Help for this menu
q) Return to previous menu

HINT: Enter 5 to edit DBNAME, then 3 to load

Enter selection (1-15, h, or q): 8


Enter new setting for UserId [QEDMO]:PS



------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: DMOHRMS9
------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr : Yes 5) DBNAME :[DMOHRMS9]
2) App Eng Server : Yes 6) DBTYPE :[ORACLE]
7) PrcsServer :[PSUNX]
8) UserId :[PS]
9) UserPswd :[QEDMO]
10) ConnectID :[people]
11) ConnectPswd:[peop1e]
12) ServerName :[]
Actions 13) Log/Output Dir:[%PS_SERVDIR%/log_output]
========= 14) SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
3) Load config as shown 15) AddToPATH :[%PS_HOME%/cblbin]
4) Custom configuration
h) Help for this menu
q) Return to previous menu

Enter selection (1-15, h, or q): 9


Enter new setting for UserPswd [QEDMO]:PS



------------------------------------------------------------
Quick-configure menu -- Scheduler for Database: DMOHRMS9
------------------------------------------------------------
Features Settings
========== ==========
1) Master Schdlr : Yes 5) DBNAME :[DMOHRMS9]
2) App Eng Server : Yes 6) DBTYPE :[ORACLE]
7) PrcsServer :[PSUNX]
8) UserId :[PS]
9) UserPswd :[PS]
10) ConnectID :[people]
11) ConnectPswd:[peop1e]
12) ServerName :[]
Actions 13) Log/Output Dir:[%PS_SERVDIR%/log_output]
========= 14) SQRBIN :[%PS_HOME%/bin/sqr/%PS_DB%/bin]
3) Load config as shown 15) AddToPATH :[%PS_HOME%/cblbin]
4) Custom configuration
h) Help for this menu
q) Return to previous menu

Enter selection (1-15, h, or q): 3
Loading validation table...
setting DBName=DMOHRMS9
setting DBType=ORACLE
setting UserId=PS
setting UserPswd=PS
setting ConnectId=people
setting ConnectPswd=peop1e
setting ServerName=
setting PrcsServerName=PSUNX
setting Log/Output Directory=%PS_SERVDIR%/log_output
setting Add to PATH=%PS_HOME%/cblbin
setting SQRBIN=%PS_HOME%/bin/sqr/%PS_DB%/bin
New CFG file written with modified Startup parameters

Spawning enabled for server PSDSTSRV.
Configuration file successfully created.
CFG setting changes completed, loading configuration...
Process Scheduler Server configuration complete.

6. Run the Process Scheduler
-------------------------------------------
PeopleSoft Process Scheduler Administration
-------------------------------------------

1) Start a Process Scheduler Server
2) Stop a Process Scheduler Server
3) Configure a Process Scheduler Server
4) Create a Process Scheduler Server Configuration
5) Delete a Process Scheduler Server Configuration
6) Edit a Process Scheduler Configuration File
7) Import an existing Process Scheduler Configuration
8) Show Status of a Process Scheduler Server
9) Kill a Process Scheduler Server
10) Clean IPC resources of a Process Scheduler Domain

q) Quit

Command to execute (1-10, q) : 1


Database list:

1) DMOHRMS9

Select item number to start: 1

No Archive subdirectory, creating it...
No psprcs.cfg in the Archive subdirectory, creating it...

Starting Process Scheduler Server PSUNX for Database DMOHRMS9 ...

Booting all admin and server processes in /apps/psoft/hrms9/appserv/prcs/DMOHRMS9/PSTUXCFG
INFO: BEA Tuxedo, Version 9.1, 32-bit, Patch Level 036
INFO: Serial #: 650522264137-2065448083901, Expiration NONE, Maxusers 1000000
INFO: Licensed to: Oracle-Peoplesoft-ISV

Booting admin processes ...

exec BBL -A :
process id=13307 ... Started.

Booting server processes ...

exec PSMSTPRC -A -- -C psprcs.cfg -CD DMOHRMS9 -PS PSUNX -A start -S PSMSTPRC :
process id=13321 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOHRMS9 -S PSAESRV :
process id=13330 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOHRMS9 -S PSAESRV :
process id=13338 ... Started.
exec PSAESRV -- -C psprcs.cfg -CD DMOHRMS9 -S PSAESRV :
process id=13346 ... Started.
exec PSDSTSRV -p 1,600:1,1 -sPostReport -- -C psprcs.cfg -CD DMOHRMS9 -PS PSUNX -A start -S PSDSTSRV :
process id=13354 ... Started.
exec PSPRCSRV -sInitiateRequest -- -C psprcs.cfg -CD DMOHRMS9 -PS PSUNX -A start -S PSPRCSRV :
process id=13363 ... Started.
exec PSMONITORSRV -A -- -ID 215198 -C psprcs.cfg -PS PSUNX -S PSMONITORSRV :
process id=13375 ... Started.
8 processes started.

7. In Peopletools/Process Scheduler/System Process Request, add a Run Control, then Run, then choose the Process Scheduler name you are running, and check the process you want to run :

Enjoy with your complete Application up and running.