How to Scheduling and Running SQR from Peoplecode

Description

Peoplecode provides functions like CreateProcessRequest that allows us to create a ProcessRequest object.  Once this object is created, we can assign values to its properties and then use the Schedule method to submit the process request for scheduling.The CreateProccessRequest function takes 2 arguments. The Process Type and the Process Name.

/*Variable declaration*/
Local ProcessRequest &MYPrcsRqst; 
Local String &MySQR;

&MySQR = "InsTmpTbl"

/* Creating Process Request Object*/
&MYPrcsRqst = CreateProcessRequest("SQR Process", &MySQR);

/*Specifying the runcontrol id*/
&MYPrcsRqst.RunControlID = "BATCH"

/*Specifying the output option*/
&MYPrcsRqst.SetOutputOption("Web", "PDF", "", &MySQR); 

/* Use the Schedule() method to Schedule the SQR.*/

&MYPrcsRqst.Schedule();
If &MYPrcsRqst.Status = 0 then
/* Schedule succeeded. */
Else
/* Process (job) not scheduled, do error processing */
End-If;

SHARE

peoplesoft

• 
• 
• 
• 
•