Possibly due to a sharing violation.

Make sure you're using different MAPI profiles (and different .pst
files) for SQL Mail and SQL Agent Mail. Also make sure that you never
access these mail profiles when you login onto the Server desktop. You
may need to reboot the server (not just stop and start mssqlserver) to
stop the error.

Make the profile changes first. Reboot Server.

-----Original Message-----
From: Derek Li [mailto:derek.[Email address protected]
Sent: 01 June 2006 12:46 AM
To: [Email address protected]
Subject: RE: mail session error


**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret **from
this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


.pst files not exchange server.

-----Original Message-----
From: Peter Wright [Email address protected]
Sent: Wednesday, May 31, 2006 2:31 PM
To: LazyDBA Discussion
Subject: RE: mail session error

Are you using .pst files in your MAPI profile or do you have an exchange
server?

-----Original Message-----
From: Derek Li
[mailto:mssqldba-ezmlmshield-x83367348.[Email address protected]
Sent: 30 May 2006 08:32 PM
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





---------------------------------------------------------------------
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