SQL Server 2005 Jobs
SQL Server 2005 Jobs: "I then checked the Application Log for the 2005 job failures since that is what MOM uses. I noticed that when a 2005 job failed, it wasn’t reported in the Application Log.
In SQL Server 2000, by default, the “Write to Windows application event log” “When the job fails” option is checked in the 'Notifications' tab when you create a job in Enterprise Manager.
In SQL Server 2005, this option is not checked by default."

0 Comments:
Post a Comment
Links to this post:
Create a Link
<< Home