Re: How to set the job's interval

From: Marin Dimitrov <marin_at_sirma.bg>
Date: Tue, 13 Jun 2000 12:26:03 +0300
Message-Id: <10527.108870@fatcity.com>

> Hi,can anyone tell me how to set the job's interval so that the job can
run
> at 15,30,45,60 minutes every hour.

dbms_job.submit(job_number, 'job_action;', interval=>'SYSDATE+1/96');

hope this helps,

Marin

"When brought to meaning, all importance becomes small, as in death, all life seems nothing. Knowing is destroyed by thinking, distilled into knowledge"

                                                 William Wharton, "Birdy"

Received on Tue Jun 13 2000 - 04:26:03 CDT