Submit a job in DBA_JOBS

[230173]

Hi,

I would like to submit a job in DBA_JOBS that runs every five minutes. Couls somebody help me with this?

 

[sem]

var jobno number --a handler to your job

dbms_job.submit(JOB => :jobno
,WHAT => '<your_procedure>'
,NEXT_DATE => sysdate
,INTERVAL => 'sysdate+1/288')

print jobno

Regards, Dima

http://seminihin.narod.ru

 

[THoey]

And make sure the the JOB_QUEUE_PROCESSES is set to a value of at least 1. Otherwise, there will be no services set to check for jobs to process.

Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...

 

[230173]

thanks a lot.
SO how do I submit a job that must run every day at 11:30?

 

[aryeh1010]

declare
job number;
begin
dbms_job.submit(job,
'procedure_name;',
trunc(sysdate)+23/48,
'trunc(sysdate)+1+23/48');
end;

the trunc(sysdate)+ 23/48 means today at 11:30am.
trunc(sysdate)+1+23/48 means tomorrow at 11:30am.

The command is submitted with the trunc(sysdate) command, so that the job will always start at 11:30. If submitted as 11:30 with an interval of 24 hours, it is possible for the begin time to move back, if the job takes a long time to run.