Link to home
Start Free TrialLog in
Avatar of rcjax
rcjaxFlag for United States of America

asked on

How to setup a SQL Server 2005 Maintenance Plan?

I am trying to setup a maintenance plan to do a full backup of our custom database. I go through the wizard just fine but when I go to run the maintenance plan I get the following error: Start failed for Job 'AccessNET' SQLServerAgent Error, from user sa refused because job has no steps. Microsoft SQL Server, Error: 22022.

Second thing, does anyone no of a good link that give step-by-step examples on setting up a maintenance plan in sql server 2005.

Thanks
Avatar of chapmandew
chapmandew
Flag of United States of America image

Sure,here is how you can setup a maintenance plan.  

http://blogs.techrepublic.com.com/datacenter/?p=248
OK...look in the job itself to see if there aer any steps...at least rule out the obvious :)
Avatar of rcjax

ASKER

I right clicked the database job under SQL Server Agent and went to job properties.  Under STEPS there is nothing there.
Under the steps portion is where you put the work to be done.  

If I were you, I would try to create the job from scratch using a wizard.
Avatar of rcjax

ASKER

I used the Wizard and under steps nothing is there and I still get the same error.
What edition of SQL Server...express, standard, workgroup, enterprise?
Avatar of rcjax

ASKER

SQL 2005 Standard (9.00.1)
.1399?

I think there were some serious maintenance plan bugs in the RTM release.  I would go to at least SP2 as a next step AFTER YOU TEST IT. :)
Avatar of rcjax

ASKER

I have attached the errors I get when I try to setup a maintenance plan. When I go to Steps there is not anything listed.

Is there something else I should do?  Thanks
mainplan.jpg
steps.jpg
error-22022.jpg
ASKER CERTIFIED SOLUTION
Avatar of Kevin Hill
Kevin Hill
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rcjax

ASKER

Thank you
Happy to help.  I assume that was the issue?
Avatar of rcjax

ASKER

Yes that was the issue, after installing the SSIS everything worked out fine.  

Thanks again for your help.