Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 798
  • Last Modified:

SQL Server 2012 SP1 on Windows 2012 cluster core cluster- SQL agent issue

I cannot create/edit/delete sql agent jobs. I am getting the following errors

Msg 14258, Level 16, State 1, Procedure sp_is_sqlagent_starting, Line 9
Cannot perform this operation while SQLServerAgent is starting. Try again later

a. Yes. I restarted the agent many times. failed to different node
b. Yes. Agent XP is enabled
c. Yes. SQL server is not on fibre mode
d. Yes. I tried sp_delete_job sp_create_job

No error messages on event log

Please help
0
MAK999
Asked:
MAK999
  • 4
  • 2
1 Solution
 
Haresh NikumbhSr. Tech leadCommented:
0
 
Matt BowlerDB team leadCommented:
Can you confirm the status of the agent?

EXEC xp_servicecontrol N'querystate',N'SQLServerAGENT'

Can you also review the SQL Agent error logs?
0
 
MAK999Author Commented:
1. Query State is : Running.
2. http://support.microsoft.com/kb/303287/en-us is not applicable
3. MSDTC is running on the active node and tried moving around.
4. SQLAgent is running under service account. Yes. it is local admin to all the nodes.
5. Nothing odd in sql server agent log. Some errors due to the fact that those features are not installed.

2013-05-15 05:06:55 - ! [125] Subsystem 'ANALYSISQUERY' could not be loaded (reason: A dynamic link library (DLL) initialization routine failed)
2013-05-15 05:06:55 - ! [125] Subsystem 'ANALYSISCOMMAND' could not be loaded (reason: A dynamic link library (DLL) initialization routine failed)
2013-05-15 05:06:55 - ! [125] Subsystem 'SSIS' could not be loaded (reason: A dynamic link library (DLL) initialization routine failed)
0
What Kind of Coding Program is Right for You?

There are many ways to learn to code these days. From coding bootcamps like Flatiron School to online courses to totally free beginner resources. The best way to learn to code depends on many factors, but the most important one is you. See what course is best for you.

 
MAK999Author Commented:
Some more information
declare @i int 
exec xp_sqlagent_is_starting @i output 
print @i 

Open in new window

--Returns 1
exec xp_sqlagent_enum_jobs 1,''

Open in new window

--Returns "SQLServerAgent is not currently running."

Actual SQLServer Agent on the cluster is up and running. I can query msdb tables.
0
 
MAK999Author Commented:
After long troubleshooting I have found that my nodes were missing .net 3.5.

Installed .net 3.5 using the below command on all the nodes and sqlagent started working normally

dism /online /enable-feature /featurename:NetFX3 /all /Source:e:\sources\sxs /LimitAccess
0
 
Matt BowlerDB team leadCommented:
That's good news. I was about to suggest that something was not right with the installation. The ability to query msdb tables is independent of the agent running, and those errors are not normal.
0
 
MAK999Author Commented:
resolved.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 4
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now