Some time ago I had the same requirement than you and I went with option 1,
using the database (I run Oracle instead of DB2, see package DBMS_JOBS for
details) for managing and scheduling jobs.
I didn't do it the Java way (option 2) because my app runs on a cluster and
the weblogic time services aren't clusterizable, I don't know about
Websphere.
Also, you have a 4th option which is using a 3rd party scheduler solution
such as Flux http://www.simscomputing.com/products/flux/ (I can't speak
about it, I've never used it).
Good luck!
-- Dani
> -----Mensaje original-----
> De: Pradeep Kumar [mailto:pradeepk@(protected)]
> Enviado el: martes, 05 de agosto de 2003 14:43
> Para: J2EEPATTERNS-INTEREST@(protected)
> Asunto: 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.
>
> 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.
>
> ====================================================================
> 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)
====================================================================
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)
