Hi all, there is a way using sql language or some C# library to add maintenance plan on sql server? thank you all. amit.
+2
A:
Yes, look at the following SPs in msdb.
MSDN... Database Maintenance Plan Stored Procedures
- sp_add_maintenance_plan
- sp_delete_maintenance_plan_db
- sp_add_maintenance_plan_db
- sp_delete_maintenance_plan_job
- sp_add_maintenance_plan_job
- sp_help_maintenance_plan
- sp_delete_maintenance_plan
Alan FL
2009-11-06 22:11:08
thank you a lot!!!!
Mazki516
2009-11-07 13:05:00
Alan hi! using those commands, how can i actually build maintenance plan to backup db?
Mazki516
2009-11-07 13:23:50
I don't remember how i did it exactly, but i run a trace while i was doing one with management studio and checked how things were done by the GUI. Good luck!
Alan FL
2009-11-07 13:56:13