Job result loged to Windows Event LOG

[NilsBevaart]

I implemented a number of jobs for my dayly backups. In the Notification options I checked the "Write to Windows Application Event Log" and chose the "When Job Fails" parameter.
However when the job completes, whatever the outcome, the event is loged in the SQL logfile and the Windows event log. Due to the amount of backups performed, this eats up most of the logfile, making it hard to see any errors in the log.

Am I doing something wrong or is this a bug in SQL 2000 Advanced Server SP3?


Nils Bevaart

 

[nigelrivett]

I always log backups to a table in an admin database and run a query on that to see any filures.
For many servers I'll have a central admin database which records everything.

I'll usually have a single SP that runs all the backups and admin tasks on a server.

======================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.

 

[NilsBevaart]

This can be very helpfull in monitoring the backups. How can I prevent the succesfull backups from poluting my eventlog?
In the job I selected only to LOG the failures.

Nils Bevaart