Solved

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

Posted on 2013-05-15
7
760 Views
Last Modified: 2013-05-24
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
Comment
Question by:MAK999
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2
7 Comments
 
LVL 22

Expert Comment

by:Haresh Nikumbh
ID: 39167481
0
 
LVL 10

Expert Comment

by:Matt Bowler
ID: 39167521
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
 

Author Comment

by:MAK999
ID: 39167653
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
MS Dynamics Made Instantly Simpler

Make Your Microsoft Dynamics Investment Count  & Drastically Decrease Training Time by Providing Intuitive Step-By-Step WalkThru Tutorials.

 

Author Comment

by:MAK999
ID: 39168742
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
 

Accepted Solution

by:
MAK999 earned 0 total points
ID: 39169689
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
 
LVL 10

Expert Comment

by:Matt Bowler
ID: 39169708
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
 

Author Closing Comment

by:MAK999
ID: 39193731
resolved.
0

Featured Post

Microsoft Certification Exam 74-409

Veeam® is happy to provide the Microsoft community with a study guide prepared by MVP and MCT, Orin Thomas. This guide will take you through each of the exam objectives, helping you to prepare for and pass the examination.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
SQL Throw Error 7 35
help converting varchar to date 14 25
SQL- GROUP BY 4 25
add stored proc on publlication 4 20
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
This article shows gives you an overview on SQL Server 2016 row level security. You will also get to know the usages of row-level-security and how it works
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…

726 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question