x
login about faq Site discussion (meta-askssc)

re sql server 2000 server agent

MSDB became suspect in sql server 2000 and the MSDB backup was taken from other office database and restored, after that in services sql server agent log on the domain and the password was given, but it never get started I get the error.

more ▼

asked Nov 29 '11 at 08:12 AM in Default

epeneth gravatar image

epeneth
11 1 1

What error?

Nov 29 '11 at 08:52 AM ThomasRushton ♦

"SQL server agent has been stopped because it has NO WORK TO DO......"

Nov 29 '11 at 09:25 AM epeneth
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Modify the service account to use the right login and password. You can do this through the Configuration manager.

more ▼

answered Nov 29 '11 at 09:25 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
62.2k 12 20 66

still the problem persists.

Dec 01 '11 at 04:30 AM epeneth

Hmmmm... I'm not sure. You might want to try rebuilding MSDB. http://msdn.microsoft.com/en-us/library/dd207003.aspx

Dec 01 '11 at 05:01 AM Grant Fritchey ♦♦
(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x454

asked: Nov 29 '11 at 08:12 AM

Seen: 351 times

Last Updated: Nov 29 '11 at 08:12 AM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.