Posted by Neil on 02/13/06 22:13

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

• Next in forum: Re: Job Executes Only First Step
• Prev in forum: Re: SQL Server 2005 - Save tran save point name case sensitive?
• Thread view: Job Executes Only First Step

[Reply to this message]