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
rcjaxAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

http://blogs.techrepublic.com.com/datacenter/?p=248
0
Kevin HillSr. SQL Server DBACommented:
OK...look in the job itself to see if there aer any steps...at least rule out the obvious :)
0
rcjaxAuthor Commented:
I right clicked the database job under SQL Server Agent and went to job properties.  Under STEPS there is nothing there.
0
Powerful Yet Easy-to-Use Network Monitoring

Identify excessive bandwidth utilization or unexpected application traffic with SolarWinds Bandwidth Analyzer Pack.

chapmandewCommented:
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.
0
rcjaxAuthor Commented:
I used the Wizard and under steps nothing is there and I still get the same error.
0
Kevin HillSr. SQL Server DBACommented:
What edition of SQL Server...express, standard, workgroup, enterprise?
0
rcjaxAuthor Commented:
SQL 2005 Standard (9.00.1)
0
Kevin HillSr. SQL Server DBACommented:
.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. :)
0
rcjaxAuthor Commented:
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
0
Kevin HillSr. SQL Server DBACommented:
0
Kevin HillSr. SQL Server DBACommented:
SSIS is likely either not installed, or not running.  Check Services.msc for "SQL Server Integration Services"
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
rcjaxAuthor Commented:
Thank you
0
Kevin HillSr. SQL Server DBACommented:
Happy to help.  I assume that was the issue?
0
rcjaxAuthor Commented:
Yes that was the issue, after installing the SSIS everything worked out fine.  

Thanks again for your help.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2005

From novice to tech pro — start learning today.