SQL SERVER AGENT

Question

SQL SERVER AGENT

bfrederick

Newbie

Points: 3
More actions
December 4, 2008 at 6:09 am

#196860

I have a 2000 installation that the SQL SERVER AGENT will not start automatically. It is unable to be stopped also. I have rebooted several times and it will only show starting. Any suggestions?
Bob

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Carolyn Richardson SSCrazy Eights Points: 8357 More actions · Answer 1

I have been having similar problems with the SQL Server service, on 2 old SQL Server 2000 boxes after some windows patches have you tried:-

Start / Run

net stop SQLSERVERAGENT

Then

Start / Run

net start SQLSERVERAGENT

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists[/url]

bfrederick Newbie Points: 3 More actions · Answer 2

Thanks Carolyn for the quick reply. I tried this several times last night and it tells me the service cannot be stopped with net stop and if I net start it tells me that the service is being started. But it hasn't started all night. I rebooted at one time and it showed it was started but backup error was that the service has not started.

Bob

Carolyn Richardson SSCrazy Eights Points: 8357 More actions · Answer 3

I would try stopping SQL Server then setting SQL Server Agent to Manual, then starting SQL Server and then trying to start the agent manually. Just a thought but that has worked for me in the past.

Facts are stubborn things, but statistics are more pliable - Mark Twain
Carolyn
SQLServerSpecialists[/url]

Eric L Hackett SSC Eights! Points: 978 More actions · Answer 4

I use this script to start sql agent when the sql instance starts

/****** Object: Stored Procedure [dbo].[StartSqlAgent] Script Date: 12/22/2008 11:13:02 AM ******/

USE [master];

GO

SET ANSI_NULLS ON;

GO

SET QUOTED_IDENTIFIER ON;

GO

IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[StartSqlAgent]') AND OBJECTPROPERTY(id, N'IsProcedure') = 1)

BEGIN

DROP PROCEDURE [dbo].[StartSqlAgent];

END

GO

CREATE PROCEDURE [dbo].[StartSqlAgent]

AS

BEGIN

/* This procedure will attempt to start the Sql Agent

Should be set to run when SQL Server starts

*/

CREATE TABLE #Svc (

output varchar(255)

)

DECLARE @attempted int, @running bit

SELECT @attempted = 0, @running = 0

WHILE @attempted 1

BEGIN

SET @attempted = @attempted + 1

INSERT #Svc(output)

EXEC master..xp_cmdshell 'net start'

IF EXISTS (SELECT output FROM #Svc WHERE output LIKE '%SQLSERVERAGENT%')

BEGIN

SET @running = 1

PRINT 'Sql Server Agent is running.'

END

ELSE

BEGIN

PRINT 'Sql Server Agent is not running.'

EXEC master..xp_cmdshell 'net start SQLSERVERAGENT', no_output;

END

DELETE #Svc

END --WHILE

DROP TABLE #Svc

END --PROCEDURE

GO

This link will explain how to set it up to run at startup.

http://weblogs.sqlteam.com/mladenp/archive/2007/08/14/60280.aspx

DangerMouseKaBoom SSC Enthusiast Points: 191 More actions · Answer 5

Hello bf, sorry just saw this, however, it may also depend on the account you are using to start the SQL Server agent, do check on that

Vee Hall of Fame Points: 3028 More actions · Answer 6

Vee

Hall of Fame

Points: 3028

December 31, 2008 at 7:38 am

#919642

Can You post sql Agent Error log details.

DangerMouseKaBoom SSC Enthusiast Points: 191 More actions · Answer 7

hello again bf, I do agree with Vee, could you please post the error response you get ?