HiveBrain v1.2.0
Get Started
← Back to all entries
patternsqlMinor

Agent job will not run

Submitted by: @import:stackexchange-dba··
0
Viewed 0 times
agentwillnotjobrun

Problem

I created a JOB to run a simple package that runs a query and saves the results to an Excel file. If I try to run the job In SQL Management Studio I get an error saying:


SQLServerAgent is not currently running so it cannot be notified of
this action. (Microsoft SQL Server, Error: 22022).

I made sure that SQLServerAgent was in fact running and tried running the job again (from SQL Managment Studio) but still got the same message.

I found this knowledge base article which is telling me that I have to edit the Registry in order to resolve the problem.

Before I go in and start messing with the registry which is something I really don't want to do I was wondering if anyone else has experienced this problem and if they had to edit their registry to fix it?

Solution

Turns out I was connecting to a Load Balancer which redirects me to either one of 2 sql servers which are synchronized ( for better performance) the SQLServer Agent was turned on on one of the servers but it was off on the other server. I needed to create my job on the main server (which has the agent service running). I didn't know we had 2 SQL servers that were identical and that I was connecting to a different one every other time. Sorry about that, but thanks again for the helpful comments, I found some interesting things in the error logs that helped me figure this all out. Thanks again!

Context

StackExchange Database Administrators Q#29662, answer score: 2

Revisions (0)

No revisions yet.