Post reply

Backup question from Newbie

  • December 3, 2007 at 11:31 am

    #121306

    Greetings,

    My backups are running fine. Now, following a successful or unsuccessful backup, i would like to send a text message.

    Does this need to be done thru a T-SQL script or statement, or can it be accomplished with a job and/or alert ?

    thanks,

  • December 3, 2007 at 11:52 am

    #756607

    SQL Server jobs have the option to email, page, or net send a message when the job completes. Look at Notifications in the job properties.

    Greg

    Greg

  • December 3, 2007 at 12:41 pm

    #756628

    I'd follow Greg's idea, use an operator to send an alert when things finish.

    Note that I think sending an email on "positive" completion is a bad idea. You'll get used to it and stop checking. Better to alert on negatives, or on changes.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply