Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
cbeganesh
Posting Yak Master
105 Posts |
 Posted - 2011-04-18 : 09:26:04
|
| im trying to run a scheduled job and it says "error 14258: cannot perform thisoperation when sql serveragent is starting try again later" sql server agent is already running. I tried stopping and restarting sql server agent. but no use, any idea |
|
|
nigelrivett
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2011-04-18 : 09:41:02
|
| Have you looked at the event viewer?Have you refereshed the view - disconnected/reconnected?It sounds like it hasn't completed starting up.seehttp://support.microsoft.com/kb/303287and do a search for sql server 14258==========================================Cursors are useful if you don't know sql.SSIS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
Jahanzaib
Posting Yak Master
115 Posts |
Posted - 2011-04-18 : 14:09:15
|
| your agent service is till running then go to SSMS then right click on the agent service then click startwhich windows user you are using for agent service account and for sql server login tooRegards,Syed Jahanzaib Bin HassanMCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBAMy Blogwww.aureus-salah.com |
|
|
|
|
|
|
SQL SERVER AGENT