Re: select statement for checking filespace backup status
2001-10-15 10:18:20
Subject: |
Re: select statement for checking filespace backup status |
From: |
Doug Thorneycroft <dthorneycroft AT LACSD DOT ORG> |
Date: |
Mon, 15 Oct 2001 07:14:27 -0700 |
The following will return a list of filespaces that haven't backed in over one
day. Also returns the
day of week they last backed up.
select filespace_name as "Filespace", node_name as "Node",
days(current_date)-days(backup_end) as "Last Backup",dayname(backup_end) as
"Day of Week" from filespaces where (days(backup_end) < (days(current_date)-1))
On Monday, October 15, 2001 6:47 AM, Joseph Dawes [SMTP:jdawes AT CHUBB DOT COM]
wrote:
> Does anyone have a good select statement for checking filespace backup
> status on a daily basis.???
|
|
|