Derek -

Make sure that your SQLServerAgent account belongs to a Domain (and give
it local administrator rights). Then make sure that the mail profile is
setup for that account.

Hope this helps.
--Leo


-----Original Message-----
From: Derek Li
[mailto:mssqldba-ezmlmshield-x83367348.[Email address protected]
Sent: Tuesday, May 30, 2006 11:32 AM
To: LazyDBA Discussion
Subject: mail session error

I got error as Error 22022:SQLServerAgent Error: The SQLServerAgent mail
session is not running;check the mail profile and/or the SQLServerAgent
service startup account in the SQLServerAgent Properties dialog when I
try to setup email notifications for the job.
OS:2003
DB:SQL Server 2000
Microsoft Office Outlook 2003 has been installed.

Regards

Derek


---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Website : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html


MS Sql Server LazyDBA home page