Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003
    Location
    Washington, DC - USA
    Posts
    53

    Question Unanswered: Trying to run a job once with future run time

    Hi,

    We're trying to run a job based on an input from a vb.net program - the scheduler seems to be the best option to avoid a timeout issue on the application. We've created the job and the scheduler, and can call the job from the application, however the application waits while the job is being processed - which not only is inconvenient for the user, but runs the risk of an application (not Oracle) timeout.

    What we need to know is how to set up the scheduler schedules in order to set the job run time as run once 10 seconds after the command button is pressed in the application and not repeat. Ideally this would be along the lines of

    <psuedocode>
    EXEC dbms_scheduler.run_job('dbo.my_job', sysdate + 10 seconds)
    </psuedocode>

    Does anyone have any suggestions or ideas on how to accomplish this?

    Thanks!
    -T

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Talking

    Have you tried:

    Code:
    DBMS_SCHEDULER.RUN_JOB (job_name=>'dbo.my_job'
                           ,use_current_session=>FALSE);
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Sep 2003
    Location
    Washington, DC - USA
    Posts
    53
    We got it to work - we just modified the scheduler and call the job by simply enabling it.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •