SQL 2008 Job Notification Email Fails When Running SQLCMD Files
I am using SQLCMD batch files in jobs that move data between different SQL 2008 instances. My job notifications for all other jobs work, but for these I can't even get the notification that the job completed to send. Initially the job would not even show as failed even though the log file had errors in it. I added in the -b -V 1 switches and now the job will show as failed if it there is an error in the SQLCMD tasks. But still no notifications. Anyone have any experience with this?