"Joe Webb" wrote:

> SSNS is probably a bit of an overkill for this scenario.
>
> I'd probably look at scheduling a simple little VBScript that checks
> the date/time stamp on the backup files and emails it to you if
> somethings amiss.
>
> Try here:
> http://cwashington.netreach.net/depo/default.asp?topic=repository&ScriptType=vbscript&SubType=Messaging
> HTH...
>
> --
> Joe Webb
> SQL Server MVP
> http://www.sqlns.com
>
>
> ~~~
> Get up to speed quickly with SQLNS
> http://www.amazon.com/exec/obidos/tg/detail/-/0972688811
>
> I support PASS, the Professional Association for SQL Server.
> (www.sqlpass.org)
>
>
> On Thu, 18 May 2006 22:33:02 -0700, Scott
> <Scott@discussions.microsoft.com> wrote:
>
> >I currently receive a notification if my sql backup fails through sql agent.
> >
> >However, there is always an outside chance that the sql agent is not working
> >either in which case I have no notification if my backups fail.
> >
> >Perhaps one can easily write a command prompt code to monitor the dates on a
> >folder and send out an email if the dates for the backup files are not
> >current. I dont
> >know how to write such a code. If anyone uses this or any other method to
> >monitor their backups, please email the code at scott-williams@hotmail.com