I am interested to have a job running from 5:00 AM to 10:00 PM every day, every 15 minutes
Is it possible with Oracle 10g DBMS_scheduler?
You can check this form here :http://www.oracle-base.com/articles/10g/scheduler-10g.php
Hope this help
See Schedule that runs every 15 minutes starting at half-hour
So how do you apply this on a job created already?
There are two ways:
1/ drop job and create it again with new settings
2/ create schedules and then change repeat_interval using dbms_scheduler.set_attribute(name=>'<owner>.<job_name>',attribute=>'repeat_interval', value=>'...');