Post reply

SQL Agent

  • March 27, 2010 at 5:49 am

    #139563

    Hi..

    i have found the following error message in the sql server agent.

    SQLServer Error: 2812, Could not find stored procedure 'msdb.dbo.xp_sqlagent_notify'. [SQLSTATE 42000] (DisableAgentXPs)

    Pls share your knowledge how to resolve and root cause for this.

    SQL server Details:

    Sql server 2005 Standard Edition

    Service pack 1

    32 bit

    Thanks in Advance.

  • March 27, 2010 at 7:31 am

    #1140924

    hi

    did you change the server role by any chance. Check whether you are able to access msdb database with the login specified to run the job at the agent

    Regards

    VMSSanthosh

  • March 27, 2010 at 8:43 am

    #1140938

    vmssanthosh (3/27/2010)

    hi

    did you change the server role by any chance. Check whether you are able to access msdb database with the login specified to run the job at the agent

    Regards

    VMSSanthosh

    Yes,i can able to access the msdb there is no issues on that.i have log into the server by user name SA.

  • March 29, 2010 at 2:44 am

    #1141255

    Any suggestion will be appreciated.

    Thanks in Advance.

  • March 29, 2010 at 2:50 am

    #1141257

    Did you have SP1 patch recently?

    Whats values you are getting with it?

    select value, value_in_use from sys.configurations where name = 'Agent XPs'

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 29, 2010 at 2:51 am

    #1141258

    Additionally Are you taking backup of MSDB ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 29, 2010 at 9:44 am

    #1141522

    Bhuvnesh (3/29/2010)

    Did you have SP1 patch recently?

    Whats values you are getting with it?

    select value, value_in_use from sys.configurations where name = 'Agent XPs'

    Yes. i have applied service pack 1 and results of the above query

    Value Value in use

    1 1

  • March 29, 2010 at 9:49 am

    #1141525

    Bhuvnesh (3/29/2010)

    Additionally Are you taking backup of MSDB ?

    No. i have not taken the backup of MSDB.

  • March 29, 2010 at 10:57 pm

    #1141951

    May seem like a stupid question, but is anything actually not working, or are you just getting the error in the logs? Looking around, this seems to be a bug in SP1 which can mean database mail stops working, although I read something else that suggests it's a bogus error (ie just an annoyance).

  • March 30, 2010 at 12:41 am

    #1141973

    yes it happened because of SP1 i think MS has fixed this bug iin SP2.

    refer these links

    http://www.windows-tech.info/15/4b5bdaab8e755fbe.php

    http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic15824.aspx

    http://dbaspot.com/forums/sqlserver-programming/350238-sql2005-sql-agent-error.html

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 30, 2010 at 1:45 am

    #1141994

    Bhuvnesh (3/30/2010)

    yes it happened because of SP1 i think MS has fixed this bug iin SP2.

    refer these links

    http://www.windows-tech.info/15/4b5bdaab8e755fbe.php

    http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic15824.aspx

    http://dbaspot.com/forums/sqlserver-programming/350238-sql2005-sql-agent-error.html

    Thanks for your reply.

  • March 30, 2010 at 1:47 am

    #1141995

    JKG (3/29/2010)

    May seem like a stupid question, but is anything actually not working, or are you just getting the error in the logs? Looking around, this seems to be a bug in SP1 which can mean database mail stops working, although I read something else that suggests it's a bogus error (ie just an annoyance).

    Sql agent job is not running which has been created only through maintanance plan.

  • March 30, 2010 at 3:12 am

    #1142028

    sudhakara (3/30/2010)

    Thanks for your reply.

    Did it get resolve ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

  • March 30, 2010 at 5:34 am

    #1142076

    Bhuvnesh (3/30/2010)

    sudhakara (3/30/2010)

    Thanks for your reply.

    Did it get resolve ?

    Let you know once i have applied the service pack 3 on the sql server.

  • March 30, 2010 at 5:37 am

    #1142077

    SP3 or SP2 ?

    -------Bhuvnesh----------
    I work only to learn Sql Server...though my company pays me for getting their stuff done;-)

Viewing 15 posts - 1 through 15 (of 22 total)

You must be logged in to reply to this topic. Login to reply