Sql Server Agent not starting - SQL Server Forums

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.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Sql Server Agent not starting

Author

Topic

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2004-10-21 : 02:56:22

Hi there,

My Sql Server Agent is not starting. I believe it has something to do with the mail profile. We used pop3 accounts for our domain but we have moved over to exchange to handle mail internally, which rendered the pop3 accounts redundant, however the sql mail profile was still using this account. I have since changed this but still getting the problem of not being able to start the service. Here are some logs:

10/21/2004 2:43:53 PM - ? [129] SQLServerAgent starting under Windows NT service control
10/21/2004 2:44:19 PM - ? [100] Microsoft SQLServerAgent version 7.00.1063 (x86 unicode retail build) : Process ID 3444
10/21/2004 2:44:19 PM - ? [101] SQL Server vivid-tmp.ad.vivid-design.com.au version 7.00.1063 (0 connection limit)
10/21/2004 2:44:19 PM - ? [102] SQL Server ODBC driver version 3.80.747
10/21/2004 2:44:19 PM - ? [103] NetLib being used by driver is DBMSSHRN.DLL; Local host server is (local)
10/21/2004 2:44:19 PM - ? [310] 2 processor(s) and 1024 MB RAM detected
10/21/2004 2:44:19 PM - ? [339] Local computer is VIVID-TMP running Windows NT 5.0 (2195) Service Pack 4
10/21/2004 2:44:19 PM - ? [392] Using MAPI32.DLL from C:\WINNT\SYSTEM32 (version 1.0.2536.0)
10/21/2004 2:44:19 PM - ? [196] Attempting to start mail session using profile 'Outlook'...
10/21/2004 2:45:25 PM - ? [131] SQLServerAgent service stopping...
10/21/2004 2:45:55 PM - ! [240] 1 engine thread(s) failed to stop after 30 seconds of waiting
10/21/2004 2:45:55 PM - ! [311] Thread 'MailDispatcher' (ID 3512) is still running
10/21/2004 2:45:56 PM - + [098] SQLServerAgent terminated (forcefully)

Any help appreciated.

Matt

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-21 : 16:33:20

Are these from the Application Log in Event Viewer? Have you rebooted?

Tara

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2004-10-21 : 19:45:04

These error messages are from the Sql log. I was hoping to get some feedback that identifies the problem before I reboot the server.

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2004-10-21 : 20:14:59

I also tried setting the mail profile to nothing:

EXECUTE msdb.dbo.sp_set_sqlagent_properties @email_profile = 'N'

as specified here http://groups.google.com/groups?hl=en&lr=lang_en&th=3b0a19fc54ba09ea&rnum=1
but nothing happened.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-10-21 : 20:15:18

Check the Application Log in Event Viewer for better information on why it won't start.

Tara

matt_calhoon
Posting Yak Master

235 Posts

Posted - 2004-10-21 : 21:04:34

the service just hangs on starting if I run from administratot tools > Services and therefore does not give an entry in application log.

If started from a command prompt I get the following output:

Microsoft Windows 2000 [Version 5.00.2195]
(C) Copyright 1985-2000 Microsoft Corp.

C:\Documents and Settings\Administrator>net stop sqlserveragent
The SQLServerAgent service is stopping.............
The SQLServerAgent service was stopped successfully.

C:\Documents and Settings\Administrator>net start sqlserveragent
The SQLServerAgent service is starting.....................................
The SQLServerAgent service could not be started.

More help is available by typing NET HELPMSG 3523.

C:\Documents and Settings\Administrator>net stop sqlserveragent
The service could not be controlled in its present state.

More help is available by typing NET HELPMSG 2189.

C:\Documents and Settings\Administrator>NET HELPMSG 2189

The service could not be controlled in its present state.

EXPLANATION

The service is not currently accepting requests. If
the service is starting, it cannot process requests until it is fully started.

ACTION

Try the operation again in a minute or two.

If this problem persists, the service may be stuck in a partially running
state. Contact technical support. Be prepared to give the name of the service
and other information about the system, such as the services and applications
that were running, and the type and amount of network activity on the computer
at the time of the problem.

C:\Documents and Settings\Administrator>

fhtapia
Starting Member

9 Posts

Posted - 2004-11-12 : 12:46:23

I'm having this issue as well, EXCEPT..

SQL 2000 SP3a, the AGENT says it is running but none of the jobs will work because they all say that it won't start while the agent is starting :(

fhtapia
Starting Member

9 Posts

Posted - 2004-11-12 : 17:01:31

I had to stop the server to day and that fixed the problem w/ QA

Do not know why it failed like so :(

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources