How can we help you today? How can we help you today?

Email Verification

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.
LehighDBA
0

Comments

2 comments

Sort by
  • 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
    James Moore
    0
  • LehighDBA
    Thanks James. I think that will work fine for now. Todd.
    LehighDBA
    0

Add comment

Please sign in to leave a comment.