• Post Reply Bookmark Topic Watch Topic
  • New Topic
programming forums Java Mobile Certification Databases Caching Books Engineering Micro Controllers OS Languages Paradigms IDEs Build Tools Frameworks Application Servers Open Source This Site Careers Other Pie Elite all forums
this forum made possible by our volunteer staff, including ...
Marshals:
  • Campbell Ritchie
  • Tim Cooke
  • Ron McLeod
  • paul wheaton
  • Jeanne Boyarsky
Sheriffs:
  • Paul Clapham
  • Devaka Cooray
Saloon Keepers:
  • Tim Holloway
  • Roland Mueller
  • Himai Minh
Bartenders:

[Oracle] Scheduling to Procedure/function execution

 
Ranch Hand
Posts: 56
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Hi Greetings,

Is there any way to schedule procedure/function execution on a particular time on every day?

This is required for to run a procedure every day at 00:00 hrs.
let me know if schedular there in oracle or else suggest an alternate for this.

I know we can do with Java or even if the environment is unix we can use crontab/ctrl+m.

thanks
Ravi
 
Ranch Hand
Posts: 118
  • Mark post as helpful
  • send pies
    Number of slices to send:
    Optional 'thank-you' note:
  • Quote
  • Report post to moderator
Oracles DBMS_SCHEDULER sets up - controls job scheduling.
reply
    Bookmark Topic Watch Topic
  • New Topic