I need to design a Talend job that is dependent on another job which runs within SQL Server.
After the job is done in SQL Server it updates a FLAG table and set the job value to 1 - let's call this jobABC for example - so in SQL Server the row for this job after the job is done looks like this:
JobName Flag
jobABC 1
Is it possible within Talend to setup a job that first checks what the value is for jobABC in SQL Server and if it is 1 then execute the remaining job flow - else check again in 30 minutes and if after 30 minutes Flag is set to 1 within SQL Server then execute the job else check again in 30 minutes.. basically Talend checks and waits for the Flag to become 1 before executing the flow.
Yes, it is possible. But we need to know what product you are using. Are you using the Enterprise Edition that comes with the TAC (Talend Administration Centre) or are you using the Open Source Edition?
The job you would design is very basic. You would simply have a parent job that will run and execute a query to find out the value of the field you mention. If it is 1, then you would initiate a child job (using a tRunJob). You would decide this using a RunIf link.
The scheduling to run every 30 mins depends on what product you have. With the TAC you can simply schedule the job to run every 30 mins. Without the TAC you will need to find a scheduling tool to do this.
