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 |
|
abhinav19
Starting Member
7 Posts |
 Posted - 2005-08-02 : 00:40:38
|
| Hi AllI have made a package in to process my cube. It runs fine.But i have a problem...On certain days my database refresh is delayed in such cases how I can manipulate the schedule timings? for e.g. If i have scheduled my package at 7:00 A.M. everyday and on a certain day the database refresh occurs at 8:00 A.M. how I can defer the package execute time. I tried to disable the package but as the time passes 7:00 A.M. the next run date is updated to the next day. I also tried shutting down the SQL Server till the database is ready, this also did not help.Plz suggest!RegardsAbhinav |
|
|
ToddV
Posting Yak Master
218 Posts |
Posted - 2005-08-04 : 14:07:53
|
quote:
Originally posted by abhinav19
Hi AllI have made a package in to process my cube. It runs fine.But i have a problem...On certain days my database refresh is delayed in such cases how I can manipulate the schedule timings? for e.g. If i have scheduled my package at 7:00 A.M. everyday and on a certain day the database refresh occurs at 8:00 A.M. how I can defer the package execute time. I tried to disable the package but as the time passes 7:00 A.M. the next run date is updated to the next day. I also tried shutting down the SQL Server till the database is ready, this also did not help.Plz suggest!RegardsAbhinav
Can you use the process that refreshes the database to start the job (msdb..sp_start_job) that runs the DTS Package that processes the cube |
 |
|
|
|
|
|
Cube Process Through DTS