ADSM-L

Select statement

2002-06-04 10:24:15
Subject: Select statement
From: Rick Harderwijk <r.harderwijk AT FACTOTUM DOT NL>
Date: Tue, 4 Jun 2002 16:23:14 +0200
Hi *SMers,

I've trying to figure something out using select-statements. I want to know
what events did or didn't complete succesfully for, say, the last 24 hours.
I'm getting the results, but I only get the results since last midnight. How
do I get the results from the last 24 hours.

This is what I have so far:

select schedule_name,scheduled_start,actual_start,result from events


Anyone here who can help?

Kind regards,

Rick Harderwijk
Systems Administrator
Factotum Media BV
Oosterengweg 44
1212 CN Hilversum
P.O. Box 335
1200 AH Hilversum
The Netherlands
Tel: +31-35-6881166
Fax: +31-35-6881199
E: rharderwijk AT factotummedia DOT nl
<Prev in Thread] Current Thread [Next in Thread>
  • Select statement, Rick Harderwijk <=