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 |
|
Joozh
Posting Yak Master
145 Posts |
 Posted - 2004-12-17 : 06:40:55
|
| Hi,Previously I was performing the process of populating my DataMart and then processing my cubes via 2 separate job scheduled one after the other and with about 30 minutes idle time in-between (just in case).I now have tried to make a single job with both of the above as 2 steps (one after the other) of a single job.However when I was done, I did a right click and tried to run the newly created job but instead of what I was hoping (that the job would start, would perform the 1st step, followed by the 2nd), it instead popped up a dialog box asking (I think) which step needs to be executed :(Is there a solution so that whenthe job is scheduled to run, it should start performing the steps in the order rather than waiting for someone to select which step to perform.Will really appreciate urgent reply.Thanks & Regards.-J |
|
|
ricky_newbee
Posting Yak Master
126 Posts |
Posted - 2004-12-17 : 10:38:26
|
| Edit the Step 1. Under Advanced tab change On success Actions to Goto Next Step |
 |
|
|
|
|
|
Urgent - Scheduled job having multiple steps