Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
CanadaDBA
583 Posts |
 Posted - 2008-05-21 : 09:34:42
|
| How can I script a maintenance plan in SQL Server 2005? Canada DBA |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-21 : 14:45:23
|
| you can't but you can script the job created through Maintenance plan. In 2005, It works like a SSIS package so you change configuration and deploy wherever you want i.e to other server and file system. |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-21 : 22:12:32
|
| Jobs will not work if there is no package on target server. |
|
|
|
mdubey
Posting Yak Master
133 Posts |
Posted - 2008-05-26 : 20:16:08
|
| You can not script for Maintanance Plan(MP), but you can script out an indivual Job.In SQL 2005 there is new and great feature that you can create MP in the form of SSIS package. means you can add as much information you need for the job.ManojMCP, MCTS |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-26 : 22:10:59
|
| ???? |
|
|
|
|
|
|
Script a maintenance plan