Hi All,
I have two jobs say Job1 and Job2,and I want to Execute these jobs conditionally depending upon the rowcount of a table(Table1), which is stored separately in database and not used in either of Job1 and Job2.
For Example: If my Table1 contains zero records i.e. rowcount=0 ,then i want to execute Job1 and then Job2 and if my Table1 contains more than one record i.e rowcount >1 then want to execute Job2 directly without executing Job1.
Please help me to solve this problem.
Thanks,
Vishal J.
Excuting Job Conditionally
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 38
- Joined: Wed Oct 01, 2008 10:30 am
Excuting Job Conditionally
IBM Websphere Datastage Certified Professional
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom
-
- Participant
- Posts: 38
- Joined: Wed Oct 01, 2008 10:30 am
"Command Activity" lets you execute a shell command. This would be a SQL Command to your database to get the results from the table. This result can be check in the job sequence and can be used as the condition on whether or not to execute a job.
<a href=http://www.worldcommunitygrid.org/team/ ... TZ9H4CGVP1 target="WCGWin">
</a>
</a>
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom