Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Member Login




Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

Join Tek-Tips
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Donate Today!

Do you enjoy these
technical forums?
Donate Today! Click Here

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.
Jobs from Indeed

Link To This Forum!

Partner Button
Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

MasterRacker (MIS)
22 Jul 09 17:28
SQL 2005 SP3

I've enable database mail via SAC.  In SSMS I've set up an operator with my e-mail address.  I created a test maintenance plan that consists solely of a Notify Operator task just to send a test message.  The plan fails with the following log:

CODE

NEW COMPONENT OUTPUT
Microsoft(R) Server Maintenance Utility (Unicode) Version 9.0.4035
Report was generated on "XXXXX".
Maintenance Plan: TEstPlan
Duration: 00:00:00
Status: Warning: One or more tasks failed..
Details:
Notify Operator Task (XXXXX)
Notify Operator on Local server connection
Operator: SysAdmin
Task start: 2009-07-22T16:17:07.
Task end: 2009-07-22T16:17:08.
Failed:(-1073548784) Executing the query "EXECUTE msdb.dbo.sp_notify_operator @name=N'SysAdmin',@body=N'Test plan executed'
" failed with the following error: "Cannot insert the value NULL into column 'permission path', table '@temp'; column does not allow nulls. INSERT fails.
No global profile is configured. Specify a profile name in the @profile_name parameter.
The statement has been terminated.". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.

What am I missing?

 

Jeff
It's never too early to begin preparing for International Talk Like a Pirate Day
"The software I buy sucks,  The software I write sucks.  It's time to give up and have a beer..." - Me

MasterRacker (MIS)
24 Jul 09 14:49
I've made some progress but this still doesn't work.  What I've done (from the beginning):

1. Enable Database Mail via Surface Area Configuration
In SSMS Object Explorer:
2. Management > SQL Server Logs > Database mail> Configure...: Run the wizard to create a new account and profile and set the profile as a public profile.
3. Management > SQL Server Logs > Database mail> Send test mail: Successfullt sent a test message from the test profile to my e-mail.
4. SQL Server Agent > Operators: Created an operator with my e-mail address.
5. SQL Server Agent, right-click  & select Properties > Alert System: enabled my test profile.
6. Created a maintenance plan with a Notify Operator task set to notify my test operator.

The plan still fails.  The SQL error log message I get is [260] Unable to start mail session (reason: No mail profile defined).

There is nothing in the Notify Operator task that allows me to choose a profile, so I have to assume it's supposed to use the one I assigned to the SQL Server Agent.

Once again, what am I missing?


 

Jeff
It's never too early to begin preparing for International Talk Like a Pirate Day
"The software I buy sucks,  The software I write sucks.  It's time to give up and have a beer..." - Me

MasterRacker (MIS)
24 Jul 09 15:17
Oops, in steps 2 & 3, substitute "Management > Database Mail" for "Management > SQL Server Logs > Database Mail".

DOH!

Jeff
It's never too early to begin preparing for International Talk Like a Pirate Day
"The software I buy sucks,  The software I write sucks.  It's time to give up and have a beer..." - Me

MasterRacker (MIS)
24 Jul 09 15:54
Got it as I was documenting what I've done.  In step 2, the wizard does not automatically set the profile created to be the default profile, even if it is the 1st one.

I win!  cheers

Jeff
It's never too early to begin preparing for International Talk Like a Pirate Day
"The software I buy sucks,  The software I write sucks.  It's time to give up and have a beer..." - Me

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close