Email Verification

LehighDBA

First let me state that I don't want my successful jobs to send me email so I have them set to send on error only.

This leaves me with a small dillemma. I want to make sure that the email could get through if it was trying to. I know I can open up the interface and click on the "Test Mail" - but I don't want to do this weekly for every server.

Is there a way (like scripting a "fake" backup job) just to test email connectivity? This way I could recieve an email once a week so that I can verify connectivity?

If not - maybe this could be a feature request?

Thanks in advance.

James Moore

How about setting a job up which is bound to fail: for example:

EXECUTE master..sqlbackup '-SQL "BACKUP DATABASE [NonExistantDatabase] TO DISK=''<AUTO>'' WITH MAILTO_ONERROR = ''someone@domain.com''"'

- James

LehighDBA

Thanks James. I think that will work fine for now. Todd.