var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Agent Job Error
I have created alert to give me information for a backup that was done and since I don't have SQL Mail set up on my servers I use sp_SQLSMTPMAIL using a smtp server. The Alert is kicking off a job called EMAIL DBA which have the code below:
exec master.dbo.sp_sqlsmtpmail @vcTo = 'email@example.com', @vcBody = '
Check the [SRVR] SQL Server ErrorLog and the Application event log on the server for additional details'
This uses the Agent Token which is very powerful.
The error I get on this job is:
Executed as user: NT AUTHORITY\SYSTEM. Line 8: Incorrect syntax near '\'. [SQLSTATE 42000] (Error 170). The step failed.
If you look at the code there is no '\', so am I missing something or could this error come from the sp_SQLSMTPMAIL.
Please help thanks
Can anyone HELP out there?