Error 22022 Sql Server Mail Session Is Not Running
Contents |
up Recent PostsRecent Posts Popular TopicsPopular Topics Home Search Members Calendar Who's On Home » SQL Server 7,2000 » SQL sql server error 22022 job is already running Server Agent » SQL Mail - Error 22022: SQLServerAgent Error SQL Mail -
Microsoft Sql Server Error 22022 Job Is Already Running
Error 22022: SQLServerAgent Error Rate Topic Display Mode Topic Options Author Message kapcreationskapcreations Posted Thursday, February 27, 2003 10:00 error 22022 sql server 2012 AM Forum Newbie Group: General Forum Members Last Login: Tuesday, March 2, 2004 11:38 AM Points: 4, Visits: 1 We are trying to implement e-mail notifications when replication fails. When I go into error 22022 sql server 2008 Management > Operators, and add my name from the list of available Exchange addresses, I send a test message which pops up an error stating:"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."Can't seem to find the solution. Ideas? Post #10271 Rodrigo AcostaRodrigo Acosta Posted Thursday, February 27, 2003
Sql Server Error 22022 Job Suspended
1:52 PM SSCommitted Group: General Forum Members Last Login: Thursday, May 21, 2015 7:40 AM Points: 1,581, Visits: 8 To be able to use mail you must use a Domain login account for your sql serverices.Once you have configured that log on into windows with that account and create a mail profile with that account from the control panel and Outlook. then configure SQL.Also check for more info in the web, because mail setup can be complicated. Post #55150 Rodrigo AcostaRodrigo Acosta Posted Thursday, February 27, 2003 1:56 PM SSCommitted Group: General Forum Members Last Login: Thursday, May 21, 2015 7:40 AM Points: 1,581, Visits: 8 If you have everything configured, then check that SQL mail profiles.From EM, over Support Services, SQL mail, right click, properties.And SQL Server Agent, properties. Post #55151 kapcreationskapcreations Posted Thursday, February 27, 2003 1:58 PM Forum Newbie Group: General Forum Members Last Login: Tuesday, March 2, 2004 11:38 AM Points: 4, Visits: 1 That did the trick. I had configured the MAPI software in control panel > administrative tools > Mail, but did not set EM to use the right profile. Thanks for the help. Post #55152 technical.mgrtechnical.mgr Posted Th
New? Advanced Search Forum Database Discussions MS SQL Server 7/MS SQL Server 2000 SQL Mail Not Working If this is your first visit, be sure to check out the FAQ by clicking error 22022 sql server 2008 r2 the link above. You may have to register before you can post: click the register microsoft sql server error 22022 replication link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. Results
Sql Server Agent Error 22022
1 to 5 of 5 Thread: SQL Mail Not Working Tweet Thread Tools Show Printable Version Email this Page… Subscribe to this Thread… Display Linear Mode Switch to Hybrid Mode Switch to Threaded Mode 10-19-2001,07:50 PM http://www.sqlservercentral.com/Forums/Topic10271-110-1.aspx #1 Denise Guest SQL Mail Not Working Hi, I'm trying to send an email notification test. I get an error that reads as follows: Error 22022: SQL Server Agent Error: The SQL Server Mail Session is not running; check the mail profile and/or the SQL Server Agent service start up account in the SQL Server Agent Properties dialog. I viewed the SQL Mail properties and it shows Start. Any Suggestions? Thanks, http://forums.databasejournal.com/showthread.php?15181-SQL-Mail-Not-Working Denise Reply With Quote 10-22-2001,05:51 AM #2 David Guest SQL Mail Not Working (reply) Hi, Do you have a mail profile set-up on the server. (MS Outlook or Exchange). If not, install MS Outlook. If so, right click on the Mail icon on the desktop on the server and select properties. Click on the Show Profiles button. What is the name of the profile that starts when using MS Outlook? It should be something like MS Exchange Settings. This profile must be for the Account that starts your SQL Services. If that account does not have a mail profile, log on as that account and create one. If it does have a mail profile, then THAT name (MS Exchange settings) must be the name in SQL mail (under support services), and also in SQL Agent (under management). Hope this helps... David ------------ Denise at 10/19/01 8:50:11 PM Hi, I'm trying to send an email notification test. I get an error that reads as follows: Error 22022: SQL Server Agent Error: The SQL Server Mail Session is not running; check the mail profile and/or the SQL Server Agent service start up account in the SQL Server Agent Properties dialog. I viewed the SQL Mail properties and it shows Start. Any Suggestions? Thanks, Denise Re
SQL Server experts to answer whatever question you can come up with. Our new SQL Server Forums are live! Come on over! We've restricted the http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14999 ability to create new threads on these forums. SQL Server Forums Profile | ActiveTopics | Members | Search | ForumFAQ Register Now and get your question answered! Username: Password: Save Password Forgot your Password? All Forums SQL Server 2000 Forums SQL Server Administration (2000) Error 22022: SQLServerAgent Reply to Topic Printer Friendly Author Topic AskSQLTeam Ask SQLTeam Question USA 0 Posts Posted-04/17/2002: 09:35:50 error 22022 Tim writes "Hi,Im getting the following error and struggling to find a resolution on the web. MSSQL2000SP2, Terminal Services running on server also.Microsoft SQL-DMO(ODBC SQL State: 42000) 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.THis only appears when I create the operator and try to test the email, the error 22022 sql mailprofile, SQLServerAgent and SQLServer all start with the same user.When I test the Mail Prilfe via the SQL Server Agent props/General Tab it works...responds with no errors.Any pointers appreciated.....ThankxTim" Kevin Snow Posting Yak Master 149 Posts Posted-04/23/2002: 16:51:00 SQL mail is more than a little flaky. It is possible for it to test successfully, but not be in a state to send mail, or even be operating. You may wish to try restarting the service -HOWEVER- be careful! More often than not, I find that shutting down SQL mail just locks it up. I then have to restart SQL Agent, which is also likely to lock up. When I try to restart SQL Server, IT LOCKS UP. We've even had problems where the server failed to come back up on the first reboot. Be certain you are willing and able to physically reboot the server before shutting down SQL Agent. karlsd Starting Member 2 Posts Posted-07/26/2002: 14:49:18 i am getting the same exact error. Restarting the SQL Services only temporarly relieves the issue. After logging off and then back on the issue arrises again. I am seriously thinking that intalling Terminal Services is the