question

epeneth avatar image
epeneth asked

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.
sql-server-2000
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

ThomasRushton avatar image ThomasRushton ♦♦ commented ·
What error?
0 Likes 0 ·
epeneth avatar image epeneth commented ·
"SQL server agent has been stopped because it has NO WORK TO DO......"
0 Likes 0 ·

1 Answer

·
Grant Fritchey avatar image
Grant Fritchey answered
Modify the service account to use the right login and password. You can do this through the Configuration manager.
2 comments
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

epeneth avatar image epeneth commented ·
still the problem persists.
0 Likes 0 ·
Grant Fritchey avatar image Grant Fritchey ♦♦ commented ·
Hmmmm... I'm not sure. You might want to try rebuilding MSDB. http://msdn.microsoft.com/en-us/library/dd207003.aspx
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.