Re: How do I create a script to add the maintenance plans to sql serve
- From: "narayaana" <ugo.peltier@xxxxxxx>
- Date: Wed, 21 Mar 2007 18:00:30 +0100
maintenance plans are now SSIS (former DTS) packages,
open SSIS, this tool will enable you to create packages that you can then
deploy to any server.
"victoria" <victoria@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4D6EC150-CB2A-479A-B882-99934D0A21E7@xxxxxxxxxxxxxxxx
I have been looking to see if anyone has written a script to create the
maintenance plans in SQL 2005. The previous commands like
sp_add_maintenance_plan have all been depreciated. It appears Microsoft
don't
want you to script the creation. By having it scripted makes it easier to
ensure the plans are set up the same on all servers and less time
consuming
to install.
I tried the option of exporting and import however this doesn't work in so
far as it doesn't appear to keep the local connection or the databases
selected in the plan e.g., msdb or all user databases. It would be much
quicker to be able to run this as part of the auto install.
It appears to use this dll Microsoft.SqlServer.MaintenancePlanTasks.dll
and
other scripts I have seen runing the backend are
sp_dts_getfolder
sp_dts_addfolder
sp_dts_deletefolder
sp_dts_renamefolder
sp_dts_listfolders
sp_dts_getpackage
sp_dts_putpackage
sp_dts_deletepackage
sp_dts_listpackages
sp_dts_getpackageroles
sp_dts_setpackageroles
Does anyone have ideas on how to script out the maintenance plan creation?
.
- Prev by Date: Re: importing a file
- Next by Date: Re: Newbie looking for advice on method of importing Excel workbook with group and detail records on first worksheet
- Previous by thread: Re: importing a file
- Next by thread: Re: How do I create a script to add the maintenance plans to sql s
- Index(es):
Relevant Pages
|
