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 |
|
vbabs02
Starting Member
4 Posts |
 Posted - 2003-11-18 : 20:37:55
|
| Hi,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 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-19 : 12:34:36
|
| No service packs have been applied? Not a good idea. It is up to service pack 3a now. There are lots of bugs that have been fixed. But besides that, yes check the Event Log and see what is going on. Are there any errors? How long have you waited for the service to start?Tara |
 |
|
|
vbabs02
Starting Member
4 Posts |
Posted - 2003-11-20 : 18:44:42
|
| Hi Tara,Yep I am aware of the service pack 3a but the ERP system that we are running is not support by the supplier on sp3a. It is supported upto sp2. I am aware that we have to apply the service pack but the question is if this was working all the while then why stopped working now.SQLSERVER agent service in service is showing started and also under Service Manager it gives me the option to stop as the service is started. It is now almost 72 hours since the last restart and yet when I get into the jobs in enterprise manager then the ERROR 14258 POPS up.Has anyone have idea about this.CheersVinod |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2003-11-20 : 18:46:44
|
| Did you check the event log? I need to know what errors are in there.Tara |
|
|
|
vbabs02
Starting Member
4 Posts |
Posted - 2003-11-20 : 20:59:31
|
| There no error in event log pertaining to MSSQLSERVER or SQLAGENTSERVICE. I have checked the event log and last 3-4 weeks no error at all.Tks Tara. |
|
|
|
|
|
|
SQL Agent error - 14258