Waiting for a file the kicking off a job
Posted: Wed Feb 07, 2007 1:53 pm
Newbie question:
I am looking itno a process where anytime a file appears in a directory a server job is kicked off.
In the ideal world:
A file appears -> Job 1 runs, kicks of Job 2 and job 1 ends -> Job 2 waits for a file runs a process, restarts Job 1 to start the waiting process all over.
I can't put this in one job because it will create a loop.
My questions are:
Can you submit a datastage job from the command line?
Will the execute command activity, execute the command and end the job or does it wait for the command to finish.
If I have a job sitting (for hours on end) with the wait for file activity, is it going to suck up processing power for nothing.
I am looking itno a process where anytime a file appears in a directory a server job is kicked off.
In the ideal world:
A file appears -> Job 1 runs, kicks of Job 2 and job 1 ends -> Job 2 waits for a file runs a process, restarts Job 1 to start the waiting process all over.
I can't put this in one job because it will create a loop.
My questions are:
Can you submit a datastage job from the command line?
Will the execute command activity, execute the command and end the job or does it wait for the command to finish.
If I have a job sitting (for hours on end) with the wait for file activity, is it going to suck up processing power for nothing.