Hi
Regarding Oracle you can write your business logic on Oracle stored
procedure and through oracle job scheduler you can schedule and also you can
write a code in procedure to reschedule the procedure.
Regarding DB2 I do not have any idea.
Regards,
Bipin
_______________________
Bipin Kumar Gupta
iGATE Global Solutions ( formerly Mascot Systems),
106-109, MAC Commerce Park,
Annasalai, Guindy
Chennai - 600032 , India,
Phone : 91-44-22301236-39 (O) Ext. 3321
-----Original Message-----
From: Rangarajan , Suresh ( Cognizant )
[mailto:rsuresh4@(protected)]
Sent: Tuesday, August 05, 2003 6:27 PM
To: J2EEPATTERNS-INTEREST@(protected)
Subject: Re: where to put the schedular
This is a multi-part message in MIME format.
------=_NextPartTM-000-0ffc3f8c-d520-48fd-9880-1a1b95d54a81
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
You can use the
java.util.Timer and TimerTask classes for this purpose.
On startup, you can read the tables and setup the timer.
But, you can not dynamically change the values in the table...
-----Original Message-----
From: Pradeep Kumar [mailto:pradeepk@(protected)]
Sent: Tuesday, August 05, 2003 6:13 PM
To: J2EEPATTERNS-INTEREST@(protected)
Subject: where to put the schedular
Hello friends,
This may not be the right forum to ask this question. But I couldn't =
find the
appropriate forum.
I have requirement, wherein I will have to run 2 types of schedulers. I =
am
using DB2 8.1 and WebSphere 5 running on windows.
One scheduler, should wake up on a particular date and time defined in =
a
table and then updates some other tables.
Another scheduler, should wake up on a particular date and time defined =
in a
table and then sends out emails.
I think I have 3 options:
1. Define and configure the schedulers using the DB2 tools.
2. Build custom schedulers in my WebSphere application, that
periodically checks the system date with scheduled date and then updates =
the
relevant table and also sends out email using the Java mail APIs
3. write a stand alone java program and use a windows scheduler.=20
These schedulers are purely back-end activities and do not depend on the =
user
actions. The first option may be the appropriate one, but I am not sure =
about
the implications.
Your comments are appreciated.
Thanks.
Pradeep Kumar
MindTree Consulting
91 80 6711777 Xtn: 2033
DISCLAIMER:
This message (including attachment if any) is confidential and may be =
privileged. Before opening attachments please check them for viruses and =
defects. MindTree Consulting Private Limited (MindTree) will not be =
responsible for any viruses or defects or any forwarded attachments =
emanating either from within MindTree or outside. If you have received =
this message by mistake please notify the sender by return e-mail and =
delete this message from your system. Any unauthorized use or =
dissemination of this message in whole or in part is strictly =
prohibited. Please note that e-mails are susceptible to change and =
MindTree shall not be liable for any improper, untimely or incomplete =
transmission.
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Community Web Site (Core J2EE Patterns Catalog - Online Version):
http://java.sun.com/blueprints/corej2eepatterns
Getting Started (Beta Version):
=
http://developer.java.sun.com/developer/technicalArticles/J2EE/patterns/
Get the book:
http://www.amazon.com/exec/obidos/ASIN/0130648841/corej2eepatte-20
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing:
email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3
D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D
Community Web Site (Core J2EE Patterns Catalog - Online Version):
http://java.sun.com/blueprints/corej2eepatterns
Getting Started (Beta Version):
http://developer.java.sun.com/developer/technicalArticles/J2EE/patterns/
Get the book:
http://www.amazon.com/exec/obidos/ASIN/0130648841/corej2eepatte-20
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing:
email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
------=_NextPartTM-000-0ffc3f8c-d520-48fd-9880-1a1b95d54a81
Content-Type: text/plain;
name="InterScan_Disclaimer.txt"
Content-Transfer-Encoding: 7bit
Content-Disposition: attachment;
filename="InterScan_Disclaimer.txt"
This e-mail and any files transmitted with it are for the sole use of the
intended recipient(s) and may contain confidential and privileged
information.
If you are not the intended recipient, please contact the sender by reply
e-mail and destroy all copies of the original message.
Any unauthorised review, use, disclosure, dissemination, forwarding,
printing or copying of this email or any action taken in reliance on this
e-mail is strictly
prohibited and may be unlawful.
Visit us at http://www.cognizant.com
====================================================================
Community Web Site (Core J2EE Patterns Catalog - Online Version):
http://java.sun.com/blueprints/corej2eepatterns
Getting Started (Beta Version):
http://developer.java.sun.com/developer/technicalArticles/J2EE/patterns/
Get the book:
http://www.amazon.com/exec/obidos/ASIN/0130648841/corej2eepatte-20
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing:
email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
------=_NextPartTM-000-0ffc3f8c-d520-48fd-9880-1a1b95d54a81--
====================================================================
Community Web Site (Core J2EE Patterns Catalog - Online Version):
http://java.sun.com/blueprints/corej2eepatterns
Getting Started (Beta Version):
http://developer.java.sun.com/developer/technicalArticles/J2EE/patterns/
Get the book:
http://www.amazon.com/exec/obidos/ASIN/0130648841/corej2eepatte-20
List Archive:
http://archives.java.sun.com/archives/j2eepatterns-interest.html
Unsubscribing:
email "signoff J2EEPATTERNS-INTEREST" to listserv@(protected)
