I believe that the best that you can do is search the ACTLOG
table for specific message numbers. For example, we run the
following query on a daily basis to find machines which have
missed their daily schedule. Similar queries could be constructed
to search for the successful execution of administrative
schedules:

SELECT message \
FROM   actlog \
WHERE  msgno = cast('2578' as integer) \
AND    cast((current_timestamp-date_time)hours as decimal(8,0)) < 8

Note that the query is run at a specified time of the day,
and the WHERE clause is constructed to retrieve the messages
within the last eight hours, which encompasses the end of all of
our schedules.

 -- Tom

Thomas A. La Porte
DreamWorks Feature Animation
tlaporte AT anim.dreamworks DOT com

On Tue, 1 Dec 1998, Trevor Foley wrote:

>Hi Rene,
>
>The answer, which I am sure you suspect but would rather not hear, is that
>you can't. The day that I upgraded the first of our servers to V3 I went to
>rewrite our daily event report using SELECT, only to be dissappointed. I've
>talked to a number of IBM folk since, but some has given any clues as to
>when/if this will be available. Very frustrating.
>
>
>Trevor
>
>> -----Original Message-----
>> From: Lambelet,Rene,VEVEY,FC-SIL/INF. [SMTP:Rene.Lambelet AT NESTLE DOT COM]
>> Sent: Tuesday, December 01, 1998 1:54 AM
>> To:   ADSM-L AT VM.MARIST DOT EDU
>> Subject:      How to query for past events
>>
>> Hello,
>>
>> a simple question for most of you:
>>
>> how can I code an SQL query to get a list of my recent schedule events?
>>
>> I would like to list the Missed and Failed ones.
>>
>> I checked the list of adsm tables but could not find any about schedules
>> events.
>>
>> Thanks,
>>
>> Rene Lambelet
>> Nestec SA - 55, Av. Nestle - CH-1800 Vevey
>> Tel: ++41'21'924'35'43 / Fax: ++41'21'924'45'89
>> E-Mail: rene.lambelet AT nestle DOT com
>