Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Unanswered: Urgent - Scheduled job having multiple steps

    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 when the 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.

  2. #2
    Join Date
    Nov 2004
    Posts
    3

    Smile

    We get that as well when a multi-step job is started manually, always select the first step to execute the complete job. The job executes normally when run from a schedule.

  3. #3
    Join Date
    Oct 2003
    Posts
    163
    Thanks. That's a relief

    Appreciate your reply

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •