@req

This script generate a list of your requests. You can restart one or more by copy / paste the “@req2 <request id>” in the right column of the list:

sql> @req
-----------------------------------------------------
copyright thomaslundqvist.dk 2009
requestor....: XXTLQ

 req id   exe     NAME                                                  EXE
-------- -------- ----------------------------------------------------- --------------------
12841802 *(D)     XXXX Picking Interface to XXX : ,                     @req2 12841802
12841803 0(E)     XXXX Picking Interface to XXX : ,                     @req2 12841803
12841878 103      XXXX Picking Interface to XXX : ,                     @req2 12841878

 

copy/paste the request to start or enter: 


SQL> @req2 12841878
Restart Concurrent Request
-------------------------------------
copyright xls4oracle.com 2009
REQUESTOR.................: XXALF
PROGRAM_NAME..............: XX_REPORT
APPLICATION_SHORT_NAME....: XXXX
DESCRIPTION...............:
ARGUMENTS.................: 09-2009
begin fnd_global.apps_initialize(31145,54123,600,0); end;
Request 12841878
Elapsed: 00:00:01.00
SQL>
 

syntax: @req

syntax: @req2 <request_id>

Download: sql4oracle.zip

Leave a Reply