Does anyone know of a SQL Server product that would let me do the following?

Connect to the instance
Configure thresholds like,
1.Show databases not backed up in the last X days
2. Show databases that are full that have logs not backed up in the last
x days/hours.
3. Show jobs that have failed in the last x days.

I would then like to click a process button and have it bring back anything
that is outside those thresholds?, any thing like that in a windows
application?

"Sevo" <swiedner@comcast.net> wrote in message
news:UpCdnWAL8uf6PsKiXTWJkw@comcast.com...
> Does anyone know of a SQL Server product that would let me do the
following?

Not offhand, but...

You can write a query that does that with a little effort:

Something like

select database_name, backup_set_id, type, backup_size from msdb..backupset
where backup_start_date> getdate()-5

Will show you the databases and types of backups for the last 5 days.

Obviously you'll want to set the day threshold to your needs.

Combine this with a join that looks against master..sysdatabases and you can
probably return the names of databases that exist, that don't have full or
log backups.

If you want, send this via xp_sendmail (or other mail utility of your
choice) or get fancy and use a webtask and create a webpage that shows you
the current output.

(Gah, now you've got me thinking about doing this for work...)

It's pretty straight forward I'd think.


>
> Connect to the instance
> Configure thresholds like,
> 1.Show databases not backed up in the last X days
> 2. Show databases that are full that have logs not backed up in the
last
> x days/hours.
> 3. Show jobs that have failed in the last x days.
>
> I would then like to click a process button and have it bring back
anything
> that is outside those thresholds?, any thing like that in a windows
> application?
>
>