Hi friends :)

I am looking for a SQL script that reports to me when the backup is
finished.

If you do a q event * * begind f=d

Policy Domain Name: REKSTRAR
     Schedule Name: SQLDBINCR
         Node Name: NSASQL_SQL
   Scheduled Start: 04-10-2002 00:00:00
      Actual Start: 04-10-2002 00:11:39
         Completed: 04-10-2002 00:11:46
            Status: Completed
            Result: 0

i can see a status there called Completed.

But when i run the command select * from events
i cant see the column completed.


SCHEDULED_START: 2002-10-04 02:00:00.000000
   ACTUAL_START: 2002-10-04 02:00:45.000000
    DOMAIN_NAME: NYHERJI
  SCHEDULE_NAME: SQLDBINCR
      NODE_NAME: SAPNSD_SQL
         STATUS: Completed
         RESULT: 0
         REASON:


Do anyone know where the column is?

thankx in advance

Kvedja/Regards
Petur Eythorsson
Taeknimadur/Technician
IBM Certified Specialist - AIX
Tivoli Storage Manager Certified Professional
Microsoft Certified System Engineer

peddi AT itn DOT is

 Nyherji Hf              Simi TEL: +354-569-7700
 Borgartun 37            105 Iceland
 URL:                    http://www.nyherji.is