RE: [sqr-users] Running SQR thru Process scheduler as well as commandprompt

["Alexander, Steven" <Steven.Alexander@sanjoseca.gov>]

I think something else is happening, because the run control table does
exist whether you run from the process scheduler or the command line.  Which
table doesn't exist? Are you sure you have the right table name?  And this
may just be a typo in your e-mail, but the variable name is
$prcs_process_instance - you're missing the first "s".

$prcs_process_instance, $prcs_oprid, and $database_name come from items on
the SQR command line that the process scheduler uses to run your program.
The variables are set in Peoplesoft-written procedures that you can find by
following the stdapi-init call through the sqc files.  They will all
probably be null if you run it with your own command line.

-----Original Message-----
From: Vaidyanathan, Ramakrishnan (GE, Corporate,consultant)
[mailto:ramakrishnan.vaidyanathan@ge.com] 
Sent: Monday, August 21, 2006 2:51 PM
To: sqr-users@sqrug.org
Subject: [sqr-users] Running SQR thru Process scheduler as well as
commandprompt

Hi All
        I got to run a sqr thru process scheduler as well as thru command
prompt so that sqr executes accordingly. I tried checking for
$prc_process_instance and checking it for null to see whether it has been
scheduled via process scheduler.If its the case, then Iam selecting some
flds from run control table else iam giving set of input statements. When I
run the sqr thru coomand prompt, it errors out saying table does not exist.
Is there any other way apart from $prc_process_instance   to check whether
sqr is executed thru process scheduler or cmd prompt.
Thanks
Ram

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users