I want to create an alert each time sql server replication distribution
jobs/log agent jobs fails to write to the windows eventlog. Can someone tell

"bjones" schrieb:
[quoted text, click to view]

Not with an alert! To trigger an alert, the SQL Server Agent needs to read
the entries in the Windows event log. So if the replication agents can't
write to the event log, then the SQL Server Agent will never notice and no
alert can be triggered.

If the disability to write to the Windows event log is considered an error
in SQL Server (which I don't know) then you could solve this by the
'Advanced' tab in the job step of the agent ('OnFailureAction'). Define an
operator and configure the job (every agent is just a job) to send you a

double click on the Replication: Agent Failure alert. Click the browse
button to the right of the error number, Click the edit button. Select
Always write to Windows EventLog. Accept all defaults to close all dialogs.

--
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html

Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
[quoted text, click to view]