SQL Server Performance Forum – Threads Archive
Job execution logged as an errorI have a special necessity in which I need that the result of failed jobs in SQL Server Agent be logged as errors in Windows Event Viewer. Normally they are logged as Warnings. We developed a solution that uses active scripting for writing the errors in Event Viewer. However, the policy configured prevents the execution of active scripting. Is there any other way of writing the result of failed jobs as errors in Event Viewer? I was hoping that there was a configuration that could be done to change the type of event written in Event Viewer. Thanks
You can mention on the job step to raise an error whenever the step fails. Satya SKJ
Microsoft SQL Server MVP
Contributing Editor & Forums Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing.