January 14, 2010 at 6:44 am
I had many issues with sql agent jobs which occured after rebooting the computer resulted in stopping all active jobs.
THis is the error i am getting for Agent:
Error 14258: Cannot perform this operation while SQLServerAgent is starting. Try again later.
When try to check properties of table i am working with i see this
There is already an open DataReader associated with this Command which must be closed first.
Thought of dropping the table but some sys process is blocking to do it and tried to kill them but getting this error:
Msg 6107, Level 14, State 1, Line 1
Only user processes can be killed.
Experts..please suggest the best action to get back my sql agent working and drop the tables so that i can load my data again.
In such situations can i drop the database and restore ?
January 15, 2010 at 2:49 pm
Better try stopping the agent first and then see if you can drop th table.
MJ
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply