I can't seem to get a handle on this events table. The SQL you supplied isn't 
working on my server (4.1.3.0 on AIX). When I do a select with no dates in the 
where clause,
all I get is the admin scheds for the current day. Other than that, I can't get 
a thing. Is there something I'm missing??

Thanks

Guillaume Gilbert
CGI Canada




Zlatko Krastev/ACIT <acit AT ATTGLOBAL DOT NET>@VM.MARIST.EDU> on 2002-06-07 
08:54:26

Veuillez répondre à "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>

Envoyé par :   "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


Pour :    ADSM-L AT VM.MARIST DOT EDU
cc :
Objet :   Re: Select statement (using events table)

select schedule_name, status, result, reason -
from events -
where date(scheduled_start) <= current_date - cast(1 as interval day)

Zlatko Krastev
IT Consultant




Please respond to <r.harderwijk AT factotum DOT nl>
To:     "'Zlatko Krastev/ACIT'" <acit AT attglobal DOT net>
cc:

Subject:        RE: Select statement (using events table)

Hi Zlatko,

So that's the trick...

I've trying to get the startdate set, using some example statements, but I
cannot get it done it seems. Here's what I tried:

select schedule_name,status,result,reason from events where
(scheduled_start - 1 day)

Well, that doesn't work :-( (obviously because the syntax isn't right :-)
).
).
Do you happen to know how that works?

Kind regards,

Rick