Re: Scheduler question

From: Jack Applewhite <jack.applewhite_at_austinisd.org>
Date: Sat, 14 Dec 2019 18:14:18 +0000
Message-ID: <MWHPR19MB1230224E1269DC7FA1EC6675E6570_at_MWHPR19MB1230.namprd19.prod.outlook.com>



Mladen,

It's a snap using SQL Dev's Scheduler Job Creation Wizard. I just did one in about a minute. SD's Wizards are WONderful.
--

Jack C. Applewhite - Database Administrator Austin I.S.D. - MIS Department
512.414.9250 (wk)

I cannot help but notice that there is no problem between us that cannot be solved by your departure. -- Mark Twain



From: oracle-l-bounce_at_freelists.org <oracle-l-bounce_at_freelists.org> on behalf of Mladen Gogala <gogala.mladen_at_gmail.com> Sent: Saturday, December 14, 2019 11:56
To: oracle-l <oracle-l_at_freelists.org> Subject: Scheduler question

I have to schedule a job that will run first 3 sundays in the month and am not at all sure how to do it. For now, my only solution is to have a table with all Sundays until 01/01/2100 and exit if the Sunday is the 4th Sunday in the month. Is there a smarter way of doing that through the DBMS_SCHEDULER?

Regards

--

Mladen Gogala
Database Consultant
Tel: (347) 321-1217

--

http://www.freelists.org/webpage/oracle-l

Confidentiality Notice: This email message, including all attachments, is for the sole use of the intended recipient(s) and may contain confidential student and/or employee information. Unauthorized use of disclosure is prohibited under the federal Family Educational Rights & Privacy Act (20 U.S.C. ?1232g, 34 CFR Part 99, 19 TAC 247.2, Gov't Code 552.023, Educ. Code 21.355, 29 CFR 1630.14(b)(c)). If you are not the intended recipient, you may not use, disclose, copy or disseminate this information. Please call the sender immediately or reply by email and destroy all copies of the original message, including attachments.

--

http://www.freelists.org/webpage/oracle-l Received on Sat Dec 14 2019 - 19:14:18 CET

Original text of this message