Define "failed".

1)  did not run
2) ran but did missed some files
3) ran but missed some filespaces
4) all of the above
5) some combination of the above

>>> Jack.Coats AT BANKSTERLING DOT COM 3/18/2004 3:41:26 PM >>>
Ok, this is really something I don't quite know how to do.

My boss wants a report daily that has the name of nodes that failed on
their
last backup attempt, and and the last time they has a successful
completion
(or when the first started failing).

And, for those that failed last in their previous backup attempt, but
were
successful on the latest backup, when did they first fail (in a row)
and
when were they successful finally.

Of course I want to automate it so I don't want to pass any parameters
and I
will be running it as a saved query (administrative script) from the
command
line, so I can pipe the output to a mail client.

What I have is what failed during the last night, but this is beyond my
SQL
basis.