Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-04-04 : 07:59:59
|
| Suki writes "Hello,I am using SQL Server 2000, to perform a scheduled job to dts data from a server to my local server. This succeeds. When the job completes, I want to receive an email informing me that job has succeeded. I am not receiving an email!I have done the following:* Selected a profile name in Support Services, SQL Mail on both servers.* Selected a profile name in the SQL Server Agent, properties on both servers.* Added myself and the other outlook user as operators on both servers.* Can email using Outlook 2003 from my local server to the other server and vice-versa.* When I schedule a DTS package transferring data from and to my local server I receive a job completed email. When I click on test for the profile in SQL Server Agent, I get the following error message: Microsoft SQL-DMO (ODBC SQL State: 42000)Error 22022: The time-out was exceeded while the server waited for a response from SQL Server Agent. Make sure that SQL Server Agent Service is running.I see that the SQL Server Agent Service is running, so I am very confused. Please could anyone help me?" |
|
|
jason
Posting Yak Master
164 Posts |
Posted - 2005-04-04 : 15:22:37
|
| Is the mail profile associated with the SQL Server Agent account used to start the agent service? |
 |
|
|
|
|
|
SQL SERVER AGENT Error 22022: The time-out was exceeded