By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,567 Members | 1,056 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,567 IT Pros & Developers. It's quick & easy.

Job Executes Only First Step

P: n/a
I have three stored procedures that need to run nightly in SQL 7. The three
procedures are not related; but to keep the procedures from running at the
same time, I placed them as three steps of a single job. The first two steps
are set to "Goto next step" on success; the last step is set to "Quit with
success."

The job runs every night. However, only the first step/procedure is
executed. Also, the first step has a green flag next to its ID in the Steps
tab of the job properties

I suppose I could just call all three SPs from a single stored procedure
that is run nightly. But I thought that putting them as three steps in a
single job would cause all three to run. What am I doing wrong?

Thanks!

Neil
Feb 13 '06 #1
Share this Question
Share on Google+
2 Replies


P: n/a
Are you sure only the first step is executing? If you right click on the
job and choose show history, then check the checkbox to show the steps do
you see all three or only one?

--
Andrew J. Kelly SQL MVP
"Neil" <no****@nospam.net> wrote in message
news:KL****************@newsread2.news.pas.earthli nk.net...
I have three stored procedures that need to run nightly in SQL 7. The three
procedures are not related; but to keep the procedures from running at the
same time, I placed them as three steps of a single job. The first two
steps are set to "Goto next step" on success; the last step is set to "Quit
with success."

The job runs every night. However, only the first step/procedure is
executed. Also, the first step has a green flag next to its ID in the
Steps tab of the job properties

I suppose I could just call all three SPs from a single stored procedure
that is run nightly. But I thought that putting them as three steps in a
single job would cause all three to run. What am I doing wrong?

Thanks!

Neil

Feb 13 '06 #2

P: n/a
Yes, you are right. All three steps are executing. There was a problem with
the data which was giving the impression that the job wasn't executing.
Thanks!

Neil

"Andrew J. Kelly" <sq************@shadhawk.com> wrote in message
news:Os*************@TK2MSFTNGP12.phx.gbl...
Are you sure only the first step is executing? If you right click on the
job and choose show history, then check the checkbox to show the steps do
you see all three or only one?

--
Andrew J. Kelly SQL MVP
"Neil" <no****@nospam.net> wrote in message
news:KL****************@newsread2.news.pas.earthli nk.net...
I have three stored procedures that need to run nightly in SQL 7. The
three procedures are not related; but to keep the procedures from running
at the same time, I placed them as three steps of a single job. The first
two steps are set to "Goto next step" on success; the last step is set to
"Quit with success."

The job runs every night. However, only the first step/procedure is
executed. Also, the first step has a green flag next to its ID in the
Steps tab of the job properties

I suppose I could just call all three SPs from a single stored procedure
that is run nightly. But I thought that putting them as three steps in a
single job would cause all three to run. What am I doing wrong?

Thanks!

Neil


Feb 14 '06 #3

This discussion thread is closed

Replies have been disabled for this discussion.