rcjax
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
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
OK...look in the job itself to see if there aer any steps...at least rule out the obvious :)
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.
If I were you, I would try to create the job from scratch using a wizard.
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?
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. :)
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. :)
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
Is there something else I should do? Thanks
mainplan.jpg
steps.jpg
error-22022.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you
Happy to help. I assume that was the issue?
ASKER
Yes that was the issue, after installing the SSIS everything worked out fine.
Thanks again for your help.
Thanks again for your help.
http://blogs.techrepublic.com.com/datacenter/?p=248