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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-11-20 : 08:07:23
|
| Vbabs writes "Hi Team,I am new to the organization that I am working and we are running SQL Server 200O server. System has been working fine till last couple of days (It running for past two years).SQLAGENT.exe has been using almost 50% of the CPU time so yesterday I started the SQL server. I want to modify some of the SQL server JOB but when I click on the properties of any job it gives me the following error:"Error 14258 - Cannot perform this operation while SQL server agent is starting. Try again later."I checked SQLAGENTSERVICE service and it is started also in the service manager it shows as started. We have a backup job scheduled for 5 days of the weeks but since last 10-12 days it is not running.Our SQL Server is configured for thread mode processing. I checked for this error in www.support.microsoft.com but the solution given there is something to do with the fiber mode processing.Could any body tell me why am I getting this error and what is the work around. Everything has been working fine till last two weeks back. Off course SQL server is running as the base product and no service packs have been applied. Other than applying the service pack is there any other solution.RegardsVbabs" |
|
|
JohnDeere
Posting Yak Master
191 Posts |
Posted - 2003-11-20 : 08:47:26
|
| Do any of the scheduled tasks show as running?Can you reboot the server?It is always a good idea to test and then install the service packs and hot fixes as they are released.Lance Harra |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
|
|
|
ERROR 14258.