MS SQL 2005 Operator Notifications

Hi all,

My SQL 2005 server is not emailing operators when jobs are complete, for instance I have set up a maintenance plan that should email a specific operator when complete but when I check the job history this error exists:

Could not generate mail report.An exception occurred while executing a Transact-SQL statement or batch.No global profile is configured. Specify a profile name in the @profile_name parameter.

How do I reslove this?

Thanks
K
techmissAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
Daniel_PLConnect With a Mentor DB Expert/ArchitectCommented:
1. Go to Database mail
2. Right Click  Click on Configure Database mail.
3. click next
4. select Manage Profile security
5. Click Next
6. Change Default profile field to yes
7. Click next
7. click Finish
0
 
jogosCommented:
You have to setup a mail profile at

Management studio/Management/database mail then right click and 'configure database mail'
0
 
Daniel_PLDB Expert/ArchitectCommented:
Please note that profile must also be public to be default, so in step 6 click checkbox to set profile to be public.
0
 
techmissAuthor Commented:
All those properties are set correctly... any other ideas.

K
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.