Re: waking up Oracle Jobs

I think,
dbms_job.isubmit (1, 'job1;', sysdate+1/6, 'sysdate+1'); for the daily job
and
dbms_job.isubmit (2, 'job2;', sysdate+1/6, 'sysdate+7'); for the weekly job
should work.

Robert

Christ Follower <christ_follower_at_my-deja.com> schrieb in im Newsbeitrag: 84sv8q$3la$1_at_nnrp1.deja.com...
> I have two Oracle jobs in USER_JOBS. I wanted to schedule them
starting
> at 4AM (one daily and the other weekly).
>
> BEGIN
> DBMS_JOB.NEXT_DATE(job,TRUNC(SYSDATE+1)+1/6);
> END;
> /
>
> Somehow, this job does not wake up in the morning. :-(
> If I run the job manually, it works just fine. It wakes up by itself
> when the next interval due. I really don't want to come in at 4AM to
> run the job manually the first time though. Any ideas? Thanks.
>
> BEGIN
> DBMS_JOB.RUN(job);
> END;
> /
>
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Tue Jan 04 2000 - 08:55:14 CST