[OGo-Discuss] ogo task reminder

[Adam Tauno Williams]

--=-sTbzQZEHB8WR254kewbL
Content-Type: text/plain
Content-Transfer-Encoding: quoted-printable

> > FYI, the query I use is:
> > WHERE "job status" NOT IN  ( '25 done', '30 archived', '02 rejected' )=20
> > AND is control job IS NULL=20
> > AND start date <  'tomorrow'
> > AND end date < 'tomorrow'::DATE + INTERVAL '4 days'
> adding the 02_rejected makes sense to me, but I do not know what the=20
> control_job is for?

Nobody does. :) And they don't seem to occur anymore.  But if you have a
system that has been around for awhile (ours has been running since
2003?) you are likely to have some floating around in your database.

--=-sTbzQZEHB8WR254kewbL
Content-Type: application/pgp-signature; name=signature.asc
Content-Description: This is a digitally signed message part

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.5 (GNU/Linux)

iD8DBQBF/o+BLRePpNle04MRAuNCAJ9Gq5Gx1p4MOgTqBGETsfyvpMhnfQCdE16g
hV/zSo5ekb4rtM+UXEMKk3k=
=lA8Q
-----END PGP SIGNATURE-----

--=-sTbzQZEHB8WR254kewbL--