SQL Server Performance Forum – Threads Archive

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 <img src=’/community/emoticons/emotion-6.gif’ alt=’

‘ /> 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.

You have to define start step, and for each step on success action and on failure action. I guess you haven’t defined the start step.

Hey Joozh, Whenever you schedule the job and run it, it will automatically start the job from the step you define as the starting step. However, when you try to run the job manually, it will ask u to choose the step from where you need to run this job. This is a normal behavior. So schedule the job and CHILL!!! HTH
-Rajeev Lahoty

Hi, I have defined the steps properly. I think the problem only happens when Itry to run the job manually (via the right click in Enterprise Manager). If it runs as per schedule, it seems to be running fine. Any clues???

Thanks Rajeev, Just read your reply….. thanks… so I will relax now <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />

quote:Originally posted by rlahoty Hey Joozh, So schedule the job and CHILL!!! HTH
-Rajeev Lahoty

The last word of that post is always great advice! Tom Pullen
DBA, Oxfam GB

Hi Tom, LOL!!!! I like that <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Thanks for the friendly advice and trust me I try to do that everyday but there are moments when … <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />

Yes – I had a whole Friday afternoon of that feeling (see my "Bad Day At The Office" post!) Tom Pullen
DBA, Oxfam GB

HI Tom, I thought you had showed me the rest area <img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ /> Hasn’t it started yet? BTW, where do I find this post (Bad day at office")?

Here http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=6559
I am in the rest area, I have to face the mess on Monday morning! Tom Pullen
DBA, Oxfam GB

Ooopsss…. just read your post.I hope Monday will be a goodday for you and the problem will be solved. Best luck!!!! Do post back once the problem is solved. Regards and best of luck.

]]>