• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 714
  • Last Modified:

Setting up SQL Alerts event log will not stop sending messages

I have setup two alerts on sql 2005
Unable to read local eventlog (reason: The parameter is incorrect) under SQL Agents for alerting for backup failures etc and integrity on all databases.

I am getting the following message now hitting the sql server log every minute

Unable to read local eventlog (reason: The parameter is incorrect)
is this  a bug? and if so what do I need to do
0
Amanda Walshaw
Asked:
Amanda Walshaw
  • 4
1 Solution
 
bcsqlCommented:
No not a bug your alert is setup wrong. script it and lets see it.
0
 
Amanda WalshawBusiness Solutions AnalsystAuthor Commented:
USE [msdb]
GO
/****** Object:  Alert [Integrity Check]    Script Date: 11/14/2008 09:37:50 ******/
EXEC msdb.dbo.sp_add_alert @name=N'Integrity Check',
            @message_id=0,
            @severity=7,
            @enabled=1,
            @delay_between_responses=0,
            @include_event_description_in=0,
            @category_name=N'[Uncategorized]',
            @job_id=N'2edc489a-de54-485e-b087-5fb7d4d224cb'
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Integrity Check', @operator_name=N'DBA', @notification_method =1
GO
EXEC msdb.dbo.sp_add_notification @alert_name=N'Integrity Check', @operator_name=N'helpdesk', @notification_method =1
0
 
Amanda WalshawBusiness Solutions AnalsystAuthor Commented:
also getting error with regard to sql mail

test mail profile failed for jobserver xxxx
an exception occure dwhile excuting a Transact-SQL Statement or batch
(Microsoft.SQLServer.ConnectionInfo)

- SQLServerAGent Error: MAPI Logon Failed (Microsoft SQL Server, Error:  22022)

It personnel have assured me that outlook has been setup etc on the server.
0
 
Amanda WalshawBusiness Solutions AnalsystAuthor Commented:
reviewing support.microsoft.com aricle 315886 common sql mail problems
0
 
Amanda WalshawBusiness Solutions AnalsystAuthor Commented:
alerts now working will close this call and open up separte one for sql mail
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Microsoft Azure 2017

Azure has a changed a lot since it was originally introduce by adding new services and features. Do you know everything you need to about Azure? This course will teach you about the Azure App Service, monitoring and application insights, DevOps, and Team Services.

  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now