Operator doesn't send 1

[iamtechuser]

Hi,

I set up an Operator as my email address. I tested that I can mail to this email address by sending a test email. That worked ok.

However, if I use this operator in a job notification, and set it up to notify on job failure, it doesn't send to the operator from the job... when the job fails.

Help

Do I need to restart the agent to make this work?

 

[mrdenny]

Did you configure the SQL Agent to point to the Outlook profile you are trying to use?

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[iamtechuser]

Not using an Outlook profile, this is 2005

or am I confused?

Don't recall ever having to do this on 2005

thx

 

[mrdenny]

In SQL 2005 right click on the SQL Agent, and select properties. Select the Alert System page. Check the "Enable mail profile" check box and select database mail from the list and then the mail profile you wish the SQL Agent to use.

You had to do basically the same thing in SQL 2000, except you were selecting the MAPI profile to use.

Denny
MCSA (2003) / MCDBA (SQL 2000)
MCTS (SQL 2005 / Microsoft Windows SharePoint Services 3.0: Configuration / Microsoft Office SharePoint Server 2007: Configuration)
MCITP Database Administrator (SQL 2005) / Database Developer (SQL 2005)

My Blog

 

[iamtechuser]

Thanks - I also had to restart agent, now works