DBMS job interval question

From: John Dailey <John.Dailey_at_concept-solutions.com>
Date: Tue, 5 Dec 2000 11:50:33 -0500
Message-Id: <10701.123682@fatcity.com>

Greetings all. I want to schedule a job to run at midnight, 6am, noon, and 6pm each day. How would I write the job interval to schedule this, or do I have to enter the job 4 different times (i.e. 4 different job numbers) with the following intervals:

TRUNC(SYSDATE+1)
TRUNC(SYSDATE+1)+6/24
TRUNC(SYSDATE+1)+12/24
TRUNC(SYSDATE+1)+18/24

How can I combine these into one? Or is this possible?

Thanks in advance for any and all help. Anybody done this before?

John Dailey, MCSE/MCP+I
Oracle DBA & All Around Good Guy
Consultant
Concept Solutions, LLC
Phone: 703-855-8832

Concept Solutions, LLC
*Your Business Intelligence Partner*
www.concept-solutions.com Received on Tue Dec 05 2000 - 10:50:33 CST