This discussion is archived
4 Replies Latest reply: Oct 15, 2012 10:39 AM by 910485 RSS

IScripts - Create IScript to initiate an SQR outside of process scheduler

910485 Newbie
Currently Being Moderated
I have created them to schedule sqr's inside of the process scheduler and have used BAT files to kick off sqr's outside of it, but need an iscript to do it outside of the scheduler

Thanks,

Allen Cunningham
DBA - Sonoma State University
CSU System
  • 1. Re: IScripts - Create IScript to initiate an SQR outside of process scheduler
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    Why do you need to have an iScript to front this???

    If the reason is to initiate it through the browser, you could also create an Application Engine that calls the bat file using the Exec function that initiates the sqr.
    You can call the application engine to execute straight from PeopleCode, not over the process scheduler using the CallAppEngine function

    PeopleBooks:
    Description*
    Use the CallAppEngine function to start the Application Engine program named applid. This is how to start your Application Engine programs synchronously from a page. (Prior to PeopleTools 8, you could do only this using the RemoteCall function.) Normally, you won’t run Application Engine programs from PeopleCode in this manner. Rather, the bulk of your Application Engine execution will be run using the Process Scheduler, and the exception would be done using CallAppEngine

    Hakan
  • 2. Re: IScripts - Create IScript to initiate an SQR outside of process scheduler
    910485 Newbie
    Currently Being Moderated
    So all that the app engine does is 'exec mybat.bat' ? - Where would the bat file be on a unix server? When I run sqr from a bat file, the bat file is always on my client.
  • 3. Re: IScripts - Create IScript to initiate an SQR outside of process scheduler
    HakanBiroglu Oracle ACE
    Currently Being Moderated
    When you run the application engine directly from peoplecode using the CallAppEngine function the Exec function will look for the bat file in PS_HOME of the application server.

    Portion of PeopleBooks on Exec:
    +Exec(command_str [, parameter])+
    where parameter has one of the following formats:
    Boolean constant
    Exec_Constant Path_Constant+

    Using an Absolute Path
    If you do not specify anything for the second parameter, or if you specify a Boolean value, the path to PS_HOME is prefixed to the command_str.
    If you specify constant values for the second parameter, PS_HOME may or may not be prefixed, depending on the values you select.
    You can use the GetEnv function to determine the value of PS_HOME.

    See the Exec function in PeopleBooks with a lot of example on how you use this with different path types.
    http://docs.oracle.com/cd/E28394_01/pt852pbh1/eng/psbooks/tpcl/book.htm?File=tpcl/htm/tpcl02.htm#H4290

    Hakan

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points