Results 1 to 4 of 4

Thread: Execution

  1. #1
    Join Date
    Jun 2003
    Posts
    294

    Unanswered: Execution

    Is there any way to execute an activity periodically without using the Operative system (using only oracle)???

    I mean, I want to execute a procedure every 5 min, or a file every 1 hour or daily.....

    Thanks !!

  2. #2
    Join Date
    Apr 2003
    Location
    Greenville, SC (USA)
    Posts
    1,155
    Try DBMS_JOBS queue ... Schedule job to run as often as you want...

    HTH
    Gregg

  3. #3
    Join Date
    May 2004
    Location
    Redwood Shores, CA
    Posts
    68
    Quote Originally Posted by jortiz
    Is there any way to execute an activity periodically without using the Operative system (using only oracle)???

    I mean, I want to execute a procedure every 5 min, or a file every 1 hour or daily.....

    Thanks !!
    Yes, dbms_job is kind of like cron in unix.

    http://download-west.oracle.com/docs...job.htm#999107
    My way or the highway. Yeah

  4. #4
    Join Date
    Jun 2003
    Posts
    294
    I'll try !
    Thanks !!!

Posting Permissions

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