Re: How to set the job's interval

I am NOT claiming this is an "elegent" solution but it does work reliably for me.

I use "trunc(sysdate)+7+20/24" for a LONG running DBMS_UTILITY.ANALYZE_SCHEMA run every Sunday starting at 8PM. Even though it takes 4 - 5 hours to complete, it always starts at 2000 hours on Sundays reliably.

Also I I have a problem with the use of cron, which actually "bit me" last night. Needless to say for the cron job to succeed the system & the data base needs to be up. If either is down at the appointed time, the job simply does not run. With DBMS_JOB, if the instance is down at the schedule time to run, the job will be started when the instance is brought up. Of course this could have some problems, too. ;-)

So pick your poison & be aware of the limitations of your choice.

HTH & HAND! Winnie_Liu_at_infonet.com wrote:
>
> But the problem for this is, if the job run @15th minute for about 5
> minutes, then the next time it will start @35th minutes for another 5
> minutes, then the time after that will be @55th minute etc...
>
> If he does not mind that, then the formula will work.
>
> I still find that the best way to make the database to run the job in a
> particurlar time and interval is CRON!
>
> Winnie :)
>
> dgoulet_at_vicr.com on 06/13/2000 07:31:25 AM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc: (bcc: Winnie Liu/HQ/ISC)
>
> The DBMS_JOB submit and next_date procedures require a character string
> that it
> can evaluate into a date. Therefore all of the tricks you know for
> converting
> data into dates works. In your case try the following:
>
> "sysdate+(15/60)/24"
>
> The point is to get the job to start at the correct time.
>
> ____________________Reply Separator____________________
> Author: cyhu_at_eachnet.com
> Date: 6/12/00 6:58 PM
>
> 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.
> Thanks in advance.
>
> -------------------------------
>
> http://www.eachnet.com
> Tel(O)??86-21-52340871/0872*667
> E-mail??cyhu_at_eachnet.com
> ??Eachnet.com - CHINA's LARGEST ON-LINE CONSUMER TRADING COMMUNITY??
>
> -------------------------------
>
> --
> Author:
> INET: dgoulet_at_vicr.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
> --
> Author:
> INET: Winnie_Liu_at_infonet.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Charlie Mengler                               Maintenance Warehouse  
charliem_at_mwh.com                              5505 Morehouse Drive   
858-552-6229                                  San Diego, CA 92121