Hi Bigadds,
I very much appreciate your reply.
I went to the Alert System tab but there was no 'Enable Database mail'
option.
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
Many thanks
Ant
"Bigadds" wrote:
> hi
>
> 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 sqlmail.TakeThisOut@ourdomain.com 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
> >
> >
> >
> >
> >
> > >> Stay informed about: Setting up email for Operator in SQL2000 - ERROR 
FAQ
Profile
Private Messages
Log in
