Yes, using SQL Developer's Scheduler Job-creation Wizard. It's easy to specify
all the details of Notifications. Let the Wizard write all the awful
DBMS_Scheduler code.
I like command line stuff as much as anyone, but not putting together lots of
DBMS_Scheduler (and other) calls. SD's Wizards are Great! They'll generate the
SQL they issue if you really want the nitty gritty code.
--
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: Wenping Bo <wbo1@xxxxxxxxxxxxxx>
Sent: Monday, December 16, 2019 11:28
To: Jack Applewhite <jack.applewhite@xxxxxxxxxxxxx>
Cc: Mladen Gogala <gogala.mladen@xxxxxxxxx>; Ilmar Kerm <ilmar.kerm@xxxxxxxxx>;
oracle-l <oracle-l@xxxxxxxxxxxxx>
Subject: Re: Scheduler question
Has anybody configured email notifications successfully in DBMS_SCHEDULER? I
have one job that got stuck for no apparent reason, I configured an email
notification when the job run exceeds 30 mins (the job itself usually finishes
run in less than 5 mins), but I haven't got a notification even if it exceeds a
day. When I find out, I have to force stop the job, then the scheduler kicks
off the next job on time (the job runs every ten minutes on schedule). I did
get a notification for the stopped job, but that is too late. It will be nice
if the scheduler can detect the hanging job, to put an end to it is even better.
Your insights are greatly appreciated.
Wenping
On Sat, Dec 14, 2019 at 4:45 PM Jack Applewhite
<jack.applewhite@xxxxxxxxxxxxx<mailto:jack.applewhite@xxxxxxxxxxxxx>> wrote:
Or, results of SD's Wizard... FREQ=MONTHLY;BYDAY=1SUN,2SUN,3SUN
This method would, possibly, lend itself more easily to, say, 2nd, 3rd, and
4th...... FREQ=MONTHLY;BYDAY=2SUN,3SUN,4SUN
--
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@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>
<oracle-l-bounce@xxxxxxxxxxxxx<mailto:oracle-l-bounce@xxxxxxxxxxxxx>> on behalf
of Mladen Gogala <gogala.mladen@xxxxxxxxx<mailto:gogala.mladen@xxxxxxxxx>>
Sent: Saturday, December 14, 2019 12:21
To: Ilmar Kerm <ilmar.kerm@xxxxxxxxx<mailto:ilmar.kerm@xxxxxxxxx>>
Cc: oracle-l <oracle-l@xxxxxxxxxxxxx<mailto:oracle-l@xxxxxxxxxxxxx>>
Subject: Re: Scheduler question
Thanks Ilmar!
On 12/14/19 1:20 PM, Ilmar Kerm wrote:
Byday=Sun;bymonthday=1-21
On Sat, 14 Dec 2019 at 19:58, Mladen Gogala
<gogala.mladen@xxxxxxxxx<mailto:gogala.mladen@xxxxxxxxx>> wrote:
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
--
//www.freelists.org/webpage/oracle-l
--
Ilmar Kerm
--
Mladen Gogala
Database Consultant
Tel: (347) 321-1217
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.
--
Systems Analyst
Information Technology Services
Swarthmore College
500 College Ave
Swarthmore, PA 19081
(610) 328-7825
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.