troubleshooting Question

SQL server won't run my Maintenance Plan unless I start the AQL server Agent

Avatar of Tom_Hickerson
Tom_HickersonFlag for United States of America asked on
Microsoft SQL Server 2005
1 Comment1 Solution2128 ViewsLast Modified:
In SQL server management studio I have to go to SQL server agent and right click and click start, and then the maintenance plan will run, but after a reboot it won't run again until I start it again.  How can I fix this?

This is the error I get if I try and execute the maint plan when the agent is not running?

TITLE: Execute Maintenance Plan
------------------------------

Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

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

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=09.00.3068&EvtSrc=MSSQLServer&EvtID=22022&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------
ASKER CERTIFIED SOLUTION
sbagireddi

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 1 Comment.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 1 Comment.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros