Can We use Timers in PL/SQL?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Can We use Timers in PL/SQL?

  1. #1
    Join Date
    Apr 2001
    Posts
    4

    Timer in PL/SQL?

    How can we use Timers in PL/SQL?. Can we use?

    In Forms, we are using timer using Create_Timer command,
    When-Timer_Expired trigger will fire after whatever we have given time duration while creation of timer.

    Same process I want to do in PL/SQL. Is it possible in PL/SQL? and How?. Anybody help to give command in PL/SQL.


    John

    [Edited by john on 04-17-2001 at 06:29 AM]

  2. #2
    Join Date
    Apr 2001
    Posts
    10
    Do you have a specific task to achieve?

    We're using simple unix script that will sleep and wake up to check file status and decide what actions it needs to take (e.g. send out alert email).

    Alternatively, you could write a stored procedures and schedule to run them on regular time interval (good for short-running jobs only).

    Hope this helps.

  3. #3
    Join Date
    Jan 2001
    Posts
    153
    Hi

    Why donn u see at JOBS !! that should solve u r problem...checkout the docs on ORACLE JOBS..I.E. dbms_job


    Vijay.s

  4. #4
    Join Date
    Apr 2001
    Posts
    24
    Hello,

    Vbaskar is absolutely right.
    Like in forms if you want any specific task
    to execute at a particular time and also wants
    to reapeat that task again and again can go for
    DBMS_JOB package, which will help you to submit
    Your job in the job queue and your job will run
    Automatically once it will satisfy when to run your task.


Posting Permissions

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



Click Here to Expand Forum to Full Width