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
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 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
I went to the weblink but did not find the script. can you please check? Scott "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 > 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 >
