sql server programming: Job Executes Only First Step -- sql server programming

RE: Job Executes Only First Step

Mark Williams
2/13/2006 1:31:31 PM

sql server programming:

I believe that I saw this same question posted not too long ago.

The SP has to return an integer return status in order for DTS to know if it
completed successfully.

In other words, put

RETURN 0

at the bottom of your procedure.
--

[quoted text, click to view]

Re: Job Executes Only First Step

Andrew J. Kelly
2/13/2006 3:28:24 PM

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

[quoted text, click to view]

Job Executes Only First Step

Neil
2/13/2006 8:13:30 PM

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

Re: Job Executes Only First Step

Neil
2/14/2006 8:35:11 PM

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

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server programming group.