RE: Setting up email for Operator in SQL2000 - ERROR
I very much appreciate your reply.
I went to the Alert System tab but there was no 'Enable Database mail'
There is only a choice of Notifying via email/pager/not send however this is
already ticked for email. Just for your information I'm using SQL2000 so
possibly we're using different versions
> i am a noob but set up mail notification today. after alot of hair pulling
> i found i had to go to the proprties of the server agent and select alert
> system and then enable database mail. then choose database mail.
> hope this helps
> "Ant" wrote:
> > Hi,
> > I'm trying to set up an Email name for an operator to be used inSQL Agent.
> > When I test the Email Name, I get an error:
> > >
> > Error 22022: SQL Server Agent Error: The SQL Server Agent Mail session is
> > not running: Check the mail profile and/or the SQL Server Agent Service
> > startup account in the SQL Server Agent Properties dialog box.
> > >
> > I have setup a non human account in AD called sqlmail. I can send email
> > from
> > it no problem.
> > I have tried both using sqlmail & its pwd as the Service Startup account &
> > also tried using the System account. Neither of these seem to work.
> > I have also added [email protected] as the Mail Profile
> > but always get the same error.
> > Would anybody know what is going wrong here. I'd be most appreciative if
> > somebody could help out on this one.
> > Many thanks
> > Ant