how to kick off one BODI job from another BODI job?

dataservices job design
1

Hi
I am planning to kick off a BODI job just after the completion of another BODI job.
How to kick off one BODI job from another BODI job?

I know we cna use exec function to execute batch scripts, but whether that can be used to kick off BODI job too?
What should be the code?

Any help is appreciated.

Regards
Vikram

vikramvasisht (BOB member since 2008-02-18)

2

A good discussion on scheduling batch jobs within DS: https://bobj-board.org/t/177553

And another thread. See post #9: https://bobj-board.org/t/179394

The search feature is your friend. Use it.

eganjp :us: (BOB member since 2007-09-12)

3

LOL…this topic comes again and again and again and…

Simply…to put my thought again…don’t burry the chains inside jobs…it is such a crazy thing to figure out why something gets kicked on when we have a problem!!!

BEST answer is using customized ETL CONTROL tables as of these days…or CHAIN in the external scheduling tools!!!

ganeshxp :us: (BOB member since 2008-07-17)

4

@vikramvasisht

yes u can use exec function to execute batch scripts to trigger a job with in another job

n78882 :us: (BOB member since 2010-09-17)

5

Code - exec(‘cmd’,‘bat file path’,8); in a script.

Arun

Arun.K :us: (BOB member since 2011-10-18)