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 |
|
kishore chittam
Starting Member
10 Posts |
 Posted - 2007-11-16 : 01:50:51
|
| I need to create sql 2005 maintenance plan for system and user databases which includes Database integrity check and Rebuild index tasks but these two things should happen at different times. Is it possible to schedule these two tasks at different times under single database maintenance plan, if so please let me know... |
|
|
anonymous1
Posting Yak Master
185 Posts |
Posted - 2007-11-16 : 09:51:38
|
| you could modify the SSIS package (but from then on it can only be modified with BIDS) to include a execute sql task that has a WAITFOR TIME statement. that could become confussing, so a separate plan maybe the way to go |
 |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-11-17 : 00:52:42
|
| >> Is it possible to schedule these two tasks at different times under single database maintenance planYes if you applied sp2, just follow the wizard. |
|
|
|
kishore chittam
Starting Member
10 Posts |
Posted - 2007-11-17 : 03:02:06
|
| Yeah thank you...we hava a option in wizard for scheduling different tasks |
|
|
|
|
|
|
SQL 2005 Database maintenance plan