We have SQL Server 2005 setup to send out emails on job failure... This am no emails went out for failed jobs and there were several (identical) log entries as shown below
Date 2/27/2007 4:30:04 AM
Log Database Mail (Database Mail Log)
Log ID 48
Process ID 2180
Mail Item ID 29
Last Modified 2/27/2007 4:30:04 AM
Last Modified By sa
Message
Object reference not set to an instance of an object.
How can I diagnose this? I searched the forums and google groups and couldnt find this error message in the context of the database mail component of SQLServer. Thanks in advance
PS: This has been moved from the SSIS forum ... The moderator there can delete that thread
got these yesterday am and today am ... any insights?|||deleted the mail profile and all associated accounts and re-created them and that fixed the issue
No comments:
Post a Comment