Re: Concurrent Request Schedule

Brian

My solution would be to build and source a portion of code (PL/SOL) where
your check for the existence of the file.

Do not execute the process at 6:30 a.m. as your say, if the file does not
exist. Put a WAIT or time interval in the code as to when the program needs
to execute again. You may also send an e-mail based notification to the
concerned parties/administrator implying that the file was not found at so
and so time and therefore the pg ram failed to run conclusively.

A good Pl/SOL developer should be able to develop this piece within your
Concurrent executable.
Hope this helps
-- 
Swarna K Duttagupta
Cell#: 2819245273
e-mail:senigma13@xxxxxxxxx <e-mail%3Asenigma13@xxxxxxxxx>
On 2/20/09, Brian Matrose <BMatrose@xxxxxxxxx> wrote:
>
>  I have a question on concurrent requests.
>
> Here is the scenario.
>
>
>
> 1. Everyday we receive a file from an outside company. We have a script
> that runs in the morning that grabs the file and places it on our Oracle
> Financials server for processing.
>
> 2. The financials users have a concurrent request set, that they want to
> schedule everyday to process the file.
>
> If we can guarantee that the file is available at the same time every
> morning we have no problems.
>
> Ex. We receive the file at 6:00 AM and transfer it to the Oracle Financials
> server and the Financials User schedules to run their concurrent request set
> each morning at 6:30.
>
>
>
> Our problem occurs if for some reason we don't receive the file until 6:45
> AM or even later. We have suggested that the user schedule the request for
> every hour so that if we host the file late, the next running of the
> concurrent request would process it. Their issue is that they don't want
> numerous concurrent requests filling up their view request screens because
> it would be too confusing. So my question is, is their any way to schedule a
> request set to run only until it completes successfully and than stop
> running until the next day.
>
> Thanks
>
>
> Brian Matrose
> Information Technology Specialist 4
> FIT Group
> 15 Computer Drive West
> Albany, New York 12205
> 518-437-3532
>
>
>  ------------------------------
>
>  ------------------------------
> This e-mail transmission contains confidential information that is the
> property of the sender. If you are not the intended recipient, you are
> notified that any retention, disclosure, reproduction or distribution of the
> contents of this e-mail transmission, or the taking of any action in
> reliance thereon or pursuant thereto, is strictly prohibited. No warranty is
> given by NYSIF that this e-mail is free of viruses, interception or
> interference. NYSIF disclaims liability for any unauthorized opinion,
> representation, statement, offer or contract made by the sender on behalf of
> NYSIF. NYSIF's delegation of authorities, setting out who may make
> representations or contract on behalf of NYSIF, is available by contacting
> NYSIF at mailadm@xxxxxxxxxx Jurisdiction for all actions arising out of
> dealings with NYSIF shall lie only in a court of competent jurisdiction of
> the State of New York.
>

Other related posts: