?
Solved

Setting up SQL Alerts event log will not stop sending messages

Posted on 2008-11-12
5
Medium Priority
?
711 Views
Last Modified: 2012-05-05
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
Comment
Question by:Amanda Walshaw
  • 4
5 Comments
 
LVL 6

Accepted Solution

by:
bcsql earned 1500 total points
ID: 22947247
No not a bug your alert is setup wrong. script it and lets see it.
0
 

Author Comment

by:Amanda Walshaw
ID: 22955482
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
 

Author Comment

by:Amanda Walshaw
ID: 22955510
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
 

Author Comment

by:Amanda Walshaw
ID: 22955530
reviewing support.microsoft.com aricle 315886 common sql mail problems
0
 

Author Comment

by:Amanda Walshaw
ID: 22956057
alerts now working will close this call and open up separte one for sql mail
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
Integration Management Part 2
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question