Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    227

    Unanswered: scheduling stored procedures

    Hi,
    I'd like to know if I can run a package automatically.
    I have a Package MY_PACK with two procedures, this package must be run every friday to 9.00 a.m.
    Can I create a file.sql and run it automatically???? how??
    My OS is windows 2000
    Oracle 8.1.7 version
    Thanks
    Raffaele

  2. #2
    Join Date
    Aug 2002
    Posts
    1
    You can write a job to run the Package every Friday at 9p.m.

  3. #3
    Join Date
    Apr 2002
    Location
    California, USA
    Posts
    482

    Cool

    There is Oracle package DBMS_JOB which can do that.

    To get famililar with the package usage and see some examples read this Info

    Hope that helps,

    clio_usa
    OCP - DBA

    .
    .
    .

Posting Permissions

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