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 |
|
jwt
Starting Member
2 Posts |
 Posted - 2007-02-27 : 11:28:34
|
| As best I can see, the new database maintenance tool allows you to set only one schedule as you work through the wizard. (For that matter if you put multiple tasks in the database, you can not fire them off individually on a different schedule.)The solution is - of course - a different job for each task you want to have a specific schedule. Or design a database to control the workflow (possible, and arguably easier to maintain, but way too complicated, I think.)Or perhaps I am missing something. So does anyone know of a better way to do that "All-in-one" kind of database maintenance - just like ti was in 2000? |
|
|
snSQL
Master Smack Fu Yak Hacker
1837 Posts |
Posted - 2007-02-27 : 14:37:42
|
| Maintenance plans are now SSIS packages, and yes the whole plan gets executed on a schedule. For different schedules, create different plans.I'm not sure what you mean by a better way to do that "All-in-one" kind of database maintenance - just like ti was in 2000 In 2000 it wasn't all in one, each part of a maintenance plan was a separate job, now plans are one SSIS package, so I'd say they are more "all-in-one" now than before? It's different sure, but get over that. What are you missing? |
 |
|
|
|
|
|
Varing schedules on database maintenance