Hello Everyone!

      I have this script that I run once/day, but we are moving servers and
      I would like to run this every 15 min. and have a starting point of
      Friday, 8/19 at noon.  How would I change the start_date and
      start_time parameters so that it would look at my specific criteria?
      Any help is appreciated.  Thanks!

      Current
      select left(entity,10) as node_name,date(start_time) as
      date,cast(activity as varchar(8)) as activity,time(start_time) as
      start,time(end_time) as end,cast(substr(cast(end_time-start_time as
      char(20)),3,8) as char(8)) as “Duration”,cast(bytes/1024/1024 as
      decimal(6,0)) as mb,cast(affected as decimal(7,0)) as
      files,cast(successful as varchar(3)) as success from summary where
      start_time>=current_timestamp-1 day and activity=’BACKUP’ and
      schedule_name like ‘DCMOVE_0819%’ order by success,node_name

      Future????
      select left(entity,10) as node_name,date(start_time) as
      date,cast(activity as varchar(8)) as activity,time(start_time) as
      start,time(end_time) as end,cast(substr(cast(end_time-start_time as
      char(20)),3,8) as char(8)) as “Duration”,cast(bytes/1024/1024 as
      decimal(6,0)) as mb,cast(affected as decimal(7,0)) as
      files,cast(successful as varchar(3)) as success from summary where
      date(start_time)=08/19/2005 and time(start_time)>=12:00 and
      activity=’BACKUP’ and schedule_name like ‘DCMOVE_0819%’ order by
      success,node_name

********************************
Joni Moyer
Highmark
Storage Systems
Work:(717)302-6603
Fax:(717)302-5974
joni.moyer AT highmark DOT com
********************************