User login
Sponsored links
Recent blog posts
- PeopleSoft Object Type List
- PeopleSoft Data Integrity Error (124,85)
- Unwanted Save Warnings in Display Only Pages
- Breadcrumb SQL to find the Navigation path for the component in the PIA
- Application Designer Index naming convention
- How to create Trigger in DB2
- Emplid increment automatically
- How can we romove multiple duplicate rows of data printing under each Print command in SQR Program?
- How can we call Dynamic Calling section in Peoplesoft Application Engine program?
- How can we write multiple SQL Commands/Statements under one Action by using one function?
You are viewing this site as a guest. You can still ask questions and help others! Join our Dev2Dev IT Community to receive your own blog, share your knowledge, and much more.
How to run SQR program from Process sheduler
- Login to post comments
Tue, 08/17/2010 - 4:30am
Hi,
I am facing problem running sqr program in process schduler.Please provide me steps to run program in ps.
how to run the below sqr program in process scheduler.
#include 'setenv.sqc'
BEGIN-HEADING 2
PRINT 'SQR PROGRAM'() center
PRINT 'EMPID' (+1,6,20)
PRINT 'NAME' (,+2,23)
PRINT 'COUNTRY' (,+4,25)
END-HEADING
BEGIN-PROGRAM
DO PROCEDURE1
END-PROGRAM
BEGIN-PROCEDURE PROCEDURE1
#DEBUG SHOW 'START PROCEDURE1'
BEGIN-SELECT
EMPLID (+1,6,20)
NAME (,+2,23)
COUNTRY (,+4,25) ON-BREAK SKIPLINES=1
FROM PS_PERSONAL_DATA
END-SELECT
graphic (5,1,66) horz-line 40
END-PROCEDURE PROCEDURE1
Bookmark/Search this post with
Unanswered Forum Posts
| Title | Under | Posted on |
|---|---|---|
| how to send hyperlink with email in application engine program. | PeopleSoft Technical | 06/13/2013 - 12:55am |
| Saving records | PeopleSoft Technical | 06/04/2013 - 11:11am |
| can we alter a trigger in DB2 to add a new column | SQL & PL/SQL | 05/29/2013 - 1:31am |
| Required Peoplesoft HRMS Functional Training | PeopleSoft Functional | 05/07/2013 - 10:29pm |
U need to attach stdapi.sqc in your sqr program. call stdapinit procedure as the first procedure and stdapiterm as the last procedure. These procedures makes an SQR program api aware and u will be able to run the program from process scheduler. For more information, refer any delivered SQR program.