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
********************************
|