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, 2011 at 08:12 AM in Default

epeneth gravatar image

11 1 1 1

What error?
Nov 29, 2011 at 08:52 AM ThomasRushton ♦
"SQL server agent has been stopped because it has NO WORK TO DO......"
Nov 29, 2011 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, 2011 at 09:25 AM

Grant Fritchey gravatar image

Grant Fritchey ♦♦
103k 19 21 74

still the problem persists.
Dec 01, 2011 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, 2011 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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Nov 29, 2011 at 08:12 AM

Seen: 600 times

Last Updated: Nov 29, 2011 at 08:12 AM