Page 1 of 1

Control-EM and Start DataStage

Posted: 23 Apr 2014 3:48
by Nero1981
Guys, Good Day!

We have many jobs being sexecutados the control in these various jobs start job in datastage DW.

That this many licenses consumed, and our goal is to include in a job of control-m, a script that start date many stage, following the flow of execution, to reduce our consumption of licenses

How can we automate this process?

Thankful For Attention

Posted: 23 Apr 2014 9:08
by jCarlos
well, first tell us, what kind of OS are u using?

you can create a batch file to run your processes and create just a job for every batch file.

Posted: 23 Apr 2014 9:53
by Nero1981
Thank you for your attention.

Both the station environment using RedHat Linux
Control Server OS-EM with RedHat Linux with Oracle database
DataStage server with Linux RedHat OS


Posted: 23 Apr 2014 10:13
by jCarlos
it is easy then... you can create batch scripts to run your datastage processes, it's easy to control a job execution on linux based OS whenever there is a error echo a static message (read this on control-M job so it can DO NOTOK and terminate), whenever the process end ok run the next until the last one; on the last one send another static message (read this on control-M so the job can DO OK) and done.

this is the way we (on the company i work) run our DWH processes with just a few control-M Jobs.

Re: Control-EM and Start DataStage

Posted: 28 Apr 2015 11:45
by mauriziog
Consider also the use of the Control Module for DataStage: you can define jobs in DataStage without run a script and with a direct connection to DataStage.