Running Jobs in two seperate Projects

DeepakCorning · Post by **DeepakCorning** » Fri Mar 30, 2007 4:04 pm

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.

ray.wurlod · Post by **ray.wurlod** » Fri Mar 30, 2007 4:58 pm

It is not possible with a Job activity.

It is, of course, possible with an Execute Command activity.

But why?!!

DeepakCorning · Post by **DeepakCorning** » Mon Apr 02, 2007 4:12 pm

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.

DSguru2B · Post by **DSguru2B** » Mon Apr 02, 2007 5:59 pm

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.

ray.wurlod · Post by **ray.wurlod** » Mon Apr 02, 2007 10:13 pm

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?

DeepakCorning · Post by **DeepakCorning** » Tue Apr 03, 2007 8:05 am

Ray , I have suggested , but these things are not in my control.. I could have decided and designed it looong back

:D

ray.wurlod · Post by **ray.wurlod** » Tue Apr 03, 2007 10:17 pm

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.