Thursday, March 8, 2012

Adding new step to SQL Agent Job

I am attempting to add a new step to an existing sql server 2000 job. The
existing job starts upon SQL Server Agent startup. The steps consist of
running a stored procedure on several databases. The last step (4) is
simply a 'wait delay', then the steps begin again. When I insert a new step,
I receive a warning indicating that a circular reference is detected. I've
added steps to the same job in other databases, but did not receive the
warning. Is this something to be concerned about? Thanks in advance for any
suggestions.
For example,
Step 1: Process1
Step 2: Process2
Step 3: Process3
Step 4: Wait30seconds
If I attempt to insert a step between 1 and 2, the warning states:
"WARNING: Circular reference detected: Step [1] 'Process1 flows to Step[4]
'Wait30Seconds', and Step [4] 'Wait30Seconds' flows back to
Step[1]'Process1'. Are you sure that is what you want?
Thank you, Will.
"Will Alber" wrote:

> It sounds like this is exactly what you're wanting - as you want the steps
> to repeat (thus a circular reference is fine).
> This job will run forever, that's what it's warning you about.
> "danid12" <danid12@.discussions.microsoft.com> wrote in message
> news:15E030EF-B183-42B7-BCCA-53F0C456EBCB@.microsoft.com...
>
>

No comments:

Post a Comment