Post reply

Notify Operator Failing while configuring Maint Plan to another Server

  • June 21, 2009 at 8:03 am

    #131444

    -- Scenario--

    Configuring User Database Maint. Plan to a backup Server.

    Check Database Integrity - Success

    Backup Database - Success

    Maintenance Cleanup Task - Success

    Only Notify Operator task is failing.

    " failed with the following error: "No global profile is configured. Specify a profile name in the @profile_name parameter.".

    Here Database Mail is configured correctly because all other jobs/mp send the reports correcltly to the operators.

    -- My Knowledge/Doubt--

    Should the backup server also contain the SQL Server/Database mail profile for sending the reports.

    Clustered SQL Server 2005 Enterprise SP2 On windows server 2003

    Please help

  • June 21, 2009 at 9:30 am

    #1013042

    For clusters, there is an intermentant bug in SP2 where the mail stored procedures are not updated. There are also a few other changes that need to be made on clusters.

    Take a look at http://paradisj.blogspot.com/2008/08/sql-server-2005-database-mail-in.html

    SQL = Scarcely Qualifies as a Language

Viewing 2 posts - 1 through 2 (of 2 total)

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