How about a NO_OUTPUT or NO_INFOMSGS option?

aaron.bertrandaaron.bertrand Posts: 24
edited November 30, 2006 10:03AM in SQL Backup Previous Versions
I am planning to use the xp sqlbackup in a scheduled job to back up about 400 databases nightly.

The only output I want in that case is for problems, not all of the informational stuff.

The reason is, if the job fails on any database other than the 1st, all of the informational stuff makes the actual error message disappear from the sysjobhistory logs.

It would be great if we could have an option to suppress output.

Other than that, kudos for a fantastic product!

Comments

  • Brian DonahueBrian Donahue Posts: 6,590 New member
    Hello Aaron,

    I think you want to use the MAILTO_ONERROR option, which, unlike the MAILTO option, only sends an email if there was an error. In the wizard, there is an extra tick-box that specifies only emailing a log when errors occur.
Sign In or Register to comment.