Page 1 of 1
Running Jobs in two seperate Projects
Posted: Fri Mar 30, 2007 4:04 pm
by DeepakCorning
Can a Sequence activity call a job in a different project in the same server , i know I can do it with BAT file or CMD line etc. but just want to know whether its directly possible or not.
Posted: Fri Mar 30, 2007 4:58 pm
by ray.wurlod
It is not possible with a Job activity.
It is, of course, possible with an Execute Command activity.
But why?!!
Posted: Mon Apr 02, 2007 4:12 pm
by DeepakCorning
Why ? - Requirement - customer wants two different projects (each containing a particular set of jobs to be in there) and then wants to schedule them together. So I was just curious whether its possible without a BAT file or not.
Thanks For the reply.
Posted: Mon Apr 02, 2007 5:59 pm
by DSguru2B
But why not via a bat file or command line dsjob?
Or, keep seperate sequences and then schedule them one after the other. That is certainly doable.
Posted: Mon Apr 02, 2007 10:13 pm
by ray.wurlod
Why does customer want two separate projects?
Why does the "solution" not involve scheduling the job in the two separate projects (for example from a third party scheduling tool) rather than forcing DataStage to do a job that it is not designed to do?
Posted: Tue Apr 03, 2007 8:05 am
by DeepakCorning
Ray , I have suggested , but these things are not in my control.. I could have decided and designed it looong back
:D
Posted: Tue Apr 03, 2007 10:17 pm
by ray.wurlod
They ARE in your control. You are there as the (senior?) DataStage developer. Push back when the requirements are silly and solvable by sensible means.