I wanted to know how to execute a scheduler job manually. My requirement is to reschedule some jobs so I want to run them manually so that their execution for the day is complete and I can put the new time. For eg. to reschedule a job, the following command can be used:
DBMS_SCHEDULER.set_attribute (
name => 'CLUSTERPLANNINGREPORTS_JOB',
attribute => 'repeat_interval',
value => 'freq=daily; byhour=16; byminute=0; bysecond=0;');
In a similar fashion, I wanted to execute the scheduler job.
I hope my query is clear.
Please revert with the reply to my query.
Regards