Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Chennai
    Posts
    53

    Unanswered: to run procedures automatically

    pls suggest me methods to run a procedure at a specified time automatically

  2. #2
    Join Date
    Feb 2004
    Posts
    2

    Re: to run procedures automatically

    Originally posted by getmathan
    pls suggest me methods to run a procedure at a specified time automatically
    You can use dbms_job package to achieve the same.

  3. #3
    Join Date
    Feb 2004
    Posts
    45

    Re: to run procedures automatically

    You can also use the scripting facility of your OS to run a proceedure by invoking sqlplus. In Unix/Linux use cron, in Windows use at, etc...

    Originally posted by getmathan
    pls suggest me methods to run a procedure at a specified time automatically
    It was working just 5 minutes ago - I promise !

  4. #4
    Join Date
    Aug 2003
    Posts
    328

    Re: to run procedures automatically

    Can you try a scheduled task? You can set it for a certain time.

  5. #5
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89
    If the operating system is unix, u can make a crontab entry and call a script that will run the package.
    Thanks and Regards,

    Praveen Pulikunnu

Posting Permissions

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