Re: SQL command insteda of QUERY EVENT?

[Raghu S]

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: [EMAIL PROTECTED],[EMAIL PROTECTED]


                                                                                       
                    
                    Niklas Lundstrom                                                   
                    
                    <niklas.lundstrom@FORENINGSSPAR        To:     
[EMAIL PROTECTED]                    
                    BANKEN.SE>                             cc:                         
                    
                    Sent by: "ADSM: Dist Stor              Subject:     SQL command 
insteda of QUERY       
                    Manager" <[EMAIL PROTECTED]>        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