Infinite loop implementaion in Server Job

[ArijitS]

I want to design a job with infinite loop.With out any external scripting is it possible from start loop and end loop.Bcoz i see from start loop it wants start counter,increment counter,end counter.... can we make the end counter infinite(not any big digit).... plz help me to sort it out

[chulett]

I want to design a job with infinite loop.

No, you don't. Why don't we start by you explaining the problem you are trying to solve instead?

[sunil_acc]

Why do we want to go in a black hole and that too on ETL?

still i would say try start loop from 1 and make it incremental loop and end it on 0 so that will never meet condition and it will be an infinite loop. But mind it, it will screw resources....................

[JoshGeorge]

Black hole produces bizarre effects on time and space.

Why do we want to go in a black hole and that too on ETL?

[kcbland]

You cannot make a circular job design. There has to be a starting stage and an ending stage. You can start with a Transformer stage, create a stage variable and have an output link write to a passive stage. You will have an infinite number of output rows written unless you put a constraint to stop after N rows or some other condition.

[ray.wurlod]

I want to design a job with infinite loop.

Why? Are you being paid by the hour?

This is a silly requirement as stated. Please post your real requirement, as Craig asked you to do.

[ArijitS]

The requirement is simple :
There are two jobs JOB1,JOB2.JOB2 starts after completion of JOB1.Now my requrement is to run the loop of
JOB1--->JOB2 infinetly.Give me the solution.I don't want to run it from a batch/shell.....

[ArndW]

Created a counted loop in your sequence that goes from 1 to a couple of million and let that loop with a command stage of sleep {n-seconds} in the loop so that you don't use too much CPU just looping if there is nothing for the 2 jobs to do.

[ray.wurlod]

"Give me the solution"?!!!

Sir, that's what I do for a living. Only it's not "give" - it's "sell".

This site is totally supported by volunteers. You would do well to moderate your tone.