Setting up SQL Alerts event log will not stop sending messages

Posted on 2008-11-12
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
Question by:Amanda Walshaw
    LVL 6

    Accepted Solution

    No not a bug your alert is setup wrong. script it and lets see it.

    Author Comment

    by:Amanda Walshaw
    USE [msdb]
    /****** Object:  Alert [Integrity Check]    Script Date: 11/14/2008 09:37:50 ******/
    EXEC msdb.dbo.sp_add_alert @name=N'Integrity Check',
    EXEC msdb.dbo.sp_add_notification @alert_name=N'Integrity Check', @operator_name=N'DBA', @notification_method =1
    EXEC msdb.dbo.sp_add_notification @alert_name=N'Integrity Check', @operator_name=N'helpdesk', @notification_method =1

    Author Comment

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

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

    It personnel have assured me that outlook has been setup etc on the server.

    Author Comment

    by:Amanda Walshaw
    reviewing aricle 315886 common sql mail problems

    Author Comment

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

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Do You Know the 4 Main Threat Actor Types?

    Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    Data architecture is an important aspect in Software as a Service (SaaS) delivery model. This article is a study on the database of a single-tenant application that could be extended to support multiple tenants. The application is web-based develope…
    Need more eyes on your posted question? Go ahead and follow the quick steps in this video to learn how to Request Attention to your question. *Log into your Experts Exchange account *Find the question you want to Request Attention for *Go to the e…
    Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

    737 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

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now