December 30, 2008 at 11:38 am
I get this error when i double click on my job to open.
Cannot show requested dailog.(SqlMgmt)
Failed to retrive data for this request.
An Exception occured while executring T-SQL statement or batch.......
Cannot perform this operation when SQL Agent is starting. Try again later.
(MicroSoft Sql server error:14258)
This happens to all the jobs under Agent. I installed SP2 3073 patch today, does it effect any ways.
thanks
December 30, 2008 at 12:31 pm
have you tried opening the job remotely through SSMS on another machine?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 1, 2009 at 9:54 pm
On the SQL Server, check the status of the SQL Agent in Services.msc and see if it is stuck in the starting state. If it is, try restarting it manually.
Jonathan Kehayias | Principal Consultant | MCM: SQL Server 2008
My Blog | Twitter | MVP Profile
Training | Consulting | Become a SQLskills Insider
Troubleshooting SQL Server: A Guide for Accidental DBAs[/url]
January 2, 2009 at 5:15 am
In Services.msc if SQL Server agent is stuck and shows the status restarting since long...
You need to stop it from command prompt:
net stop "SQL Server Agent(MSSQLSERVER)"
Once stoped; start it:
net start "SQL Server Agent(MSSQLSERVER)"
Hope this will work 🙂
---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply