From: | "Peter Neu" <peter(dot)neu(at)gmx(dot)net> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | WG: HowTo: Scheduled User Management? |
Date: | 2006-08-24 08:52:49 |
Message-ID: | 002201c6c75a$ad7d1e40$bcc8a8c0@PCMELZER |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hello,
I have a small app which manages users in a postgresql db. I use 7.4.2.
Yesterday I got this requirement that user accounts should be valid only for
a given period. When I create a new user I will have to have two timestamps
one with now() and one with now()+6 months.
Now the tricky part: The system should check once a day if an account is
still valid and if not it should set the account to inactive and notify
somebody by mail.
How is this done the best way? I heard some stuff about doing this with a
crone job, is this necessary (db runs on linux)? My app runs in a tomcat
server so it is available all the time. Is this a job for quartz API or is
there an easier way? What would you guys suggest?
Cheers,
Pete
From | Date | Subject | |
---|---|---|---|
Next Message | Bendik Rognlien Johansen | 2006-08-24 14:52:52 | Re: Large selects |
Previous Message | Koth, Christian (DWBI) | 2006-08-24 08:38:42 | Re: Large selects |