PeopleSoft Batch Scheduling

People Tools process scheduler offer to run the job at regular schedules
What is Job: Job is collection of process which may be SQR / AE Process/COBOL / CRYSTAL that run together in serial mode
Navigation: People Tools>Process Scheduler > Jobs
Batch can be scheduled one of the following ways based on the business requirement
1. Recurrences through Process Scheduler
When: To run simple recurrence for a single job /process. Which specified by people tools
Where: People Tools > Process Scheduler > System Process Requests
How: based on run date, run time, and recurrence process will initiated this can be viewed by Process monitor
Example: System Process request SYSAUDIT recurrence schedule at each day

2. Schedule Jobset Definitions
When: if same job required to run with different run control parameter
Where: PeopleTools > Process Scheduler > Schedule Jobset Definitions
How:
1. Add a new schedule name specify the job name
2. Specify the run control ( May be its user profile specific )
3. Set the begin date and time
4. Select recurrence if required to specify the process scheduler server /by default Any server
5. Go to Schedule jobset items tab
6. Expand job on the left side view then specify the each process’s run control ID and we can specify the server for example for crystal reports needs to specify the windows servers
7. Set the job definition status to active
8. We can choose the run now button to run the instance
9. Once job went success we can see the process monitor calendar icon if you click that it will shows the all schedules for the job set
10. If no more recurrence to run the job set definition status would be completed we must change the recurrence correct then set the job definition to active
Example: Job associated with 3 different processes each process must required difference run control parameters and different servers
3. Recurrences
When: to create the custom recurrence i.e. different recurrence pattern and request settings
Where : PeopleTools > Process Scheduler > Recurrences
How:
1. Add a new value give the name of recurrence
2. Choose a option Schedule next recurrence
a) Current request is initiated
b) Prior request has completed
3. Choose either regular recurrence pattern or custom date to specific date to run the job
4. if required choose the catch up if start request date/time is before current date/time

Data Mover Script

Data Mover is one of the best utility export and imports the data in PeopleSoft database.

Example Export Data Mover Script:

set log C:\Sample01_Export.log;
set output C:\Sample01.dat;
export TABLE_NAME;

Example Import Data Mover Script:

set log C:\Sample01_Import.log;
set input C:\Sample01.dat;
import *;

Note:
1.For best practice Type table name Instead of use import *
2.We can where clause statement after the export statement
3.We can export N number of tables though adding export statement
4.Use replace all to drop the table Index to avoid the unique constraints on import
5.Use replace_data for delete the existing data and replace the new data through import
6.For best practice must use the set log statement for validation of import / export
7.For best practice while specify the log input /output must use the C:\ drive