sql server agent alert failed

So the job you are trying to run has a syntax error somewhere. If you don't know anything about what's in the job, you need to find someone who knows about the job and who can fix the problem.

And mind you, SQL Server Agent is working. It's doing what is being told do. That is, it attempts to run SQL code that is syntactically incorrect. Not surprisingly, the job will fail, but that is not a problem with Agent.

Hi @Ahmed Al Mohalami,

Thanks for your information.

Based on the fragment of the error message, it looks like there is syntax error. Are you trying to run queries?

The reason for the syntax error maybe the extraneous trailing comma, so you need to remove that comma and add a close parenthesis for valid syntax. If you are running some statements, you can also check out this article.

NOTE: Never use string concatenation or interpolation to specify SQL statement values. Instead, always use parameters for those values. The SQL statement itself never changes, just the parameter value.

Please feel free to share your issue here if you have any confused.

Best regards,

Lucy Chen

If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

Note: Please follow the steps in our Documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

https://docs.microsoft.com/en-us/answers/support/email-notifications