select schedname,message from actlog where schedname='yourschedulename'

select schedule_name,status from events

However , q event is better command to check schedule status

Regards

Raghu S Nivas
Consultant - TSM
DCM Data Systems Ltd
New Delhi
India.

e-mail: raghu AT cosmos.dcmds.co DOT in,dearaghu AT rediffmail DOT com.


                                                                                
                           
                    Niklas Lundstrom                                            
                           
                    <niklas.lundstrom@FORENINGSSPAR        To:     ADSM-L AT 
VM.MARIST DOT EDU                    
                    BANKEN.SE>                             cc:                  
                           
                    Sent by: "ADSM: Dist Stor              Subject:     SQL 
command insteda of QUERY       
                    Manager" <ADSM-L AT VM.MARIST DOT EDU>        EVENT?        
                                  
                                                                                
                           
                                                                                
                           
                    10/04/2002 12:34 AM                                         
                           
                    Please respond to "ADSM: Dist                               
                           
                    Stor Manager"                                               
                           
                                                                                
                           
                                                                                
                           



Hello

Can I run  "select something from actlog" command instead of "q event * *
..."
Where are the events saved? The actlog table?


Regards

Niklas Lundström
Swedbank