"Tim Greenwood" <tim_greenwood AT yahoo DOT com> wrote in message
news:ublgk%23cgHHA.4260@TK2MSFTNGP03.phx.gbl...
> I've setup myself as an operator and provided an email address.  I also
> setup SQL Agent to use Database Mail and setup an 'Operator Alert' profile
> just for this purpose and assigned that to SQL Agent.  Now when I run a
> job that explicitly sends a "Notify Operator Task" for testing this it
> fails with the following:
>
> Executing the query "EXECUTE msdb.dbo.sp_notify_operator @name=N'Tim
> Greenwood',@body=N'testing SQL notifications'
> " failed with the following error: "No global profile is configured.
> Specify  a profile name in the @profile_name parameter.". Possible failure
> reasons:  Problems with the query, "ResultSet" property not set correctly,
> parameters  not set correctly, or connection not established correctly.
>
>
> Shouldn't it be using the profile I setup in the SQL Agent properties?
>
> BOL also says I should be able to click the "test" button to test the
> selected profile.  This button is ghosted when I select Database Mail and
> enabled only when I select SQL Mail!!  What gives. This should be pretty
> straightforward stuff no?
>
> Thanks!
>
>
>
>