Thanks .. It works ;)
dishan_at_gmail.com wrote:
> Thanks Vitaliy Vorontsov. I'll try it n let u know 2'row
>
> On Nov 6, 4:21 pm, "Vitaliy Vorontsov" <vitaliy.voront..._at_gmail.com>
> wrote:
> > Hi,
> > In order to start this job every night at 23:58 you should change
> > INTERVAL parameter to
> > TRUNC(SYSDATE+1) + ((24*60*60 - 120)/(24*60*60))
> >
> > After successful job execution the INTERVAL value will be calculated
> > and then assigned to NEXT_DATE parameter of a job.
> > So, we needed to add +1 day to that parameter to start your job the
> > next day.
> >
> >
> >
> > dis..._at_gmail.com wrote:
> > > Hi,
> > > This is the job that schedule to run at every night 23:58pm.
> > > Can anybody please check the INTERVAL is correct or NOT.?
> > > ----------------------------------------------------------------------------------------------
> > > declare v_JobNum NUMBER;
> >
> > > BEGIN
> >
> > > DBMS_JOB.SUBMIT(
> > > v_JobNum,
> > > 'BEGIN UPDHITCOUNT(); END;',
> > > TRUNC(SYSDATE),
> > > 'TRUNC(SYSDATE) + ((24*60*60 - 180)/(24*60*60))' -- 23:58
> > > );
> >
> > > dbms_output.put_line(v_JobNum);
> >
> > > END;
> > > ----------------------------------------------------------------------------------------------
> >
> > > Thanks in advance
> >
> > > Dishan- Hide quoted text -- Show quoted text -
Received on Fri Nov 24 2006 - 00:07:00 CST
