I'm using TDI open studio on Mac for performing some ETL tasks. I've made following folder structure in Job designs :
And the job flow is as follows:
J1. ExtractVendors => tRunJob : VendorsMaster
J2. VendorsMaster => tRunJob : VendorsLookup
J3. VendorsLookup => tRunJob : LoadVendors
So when I run the job J1 it perfectly runs all the jobs from J1 to J4, one after another.
Now, I would like to automatically run this job flow on daily basis at specific time.
I came across the solution for this HERE . So, I exported all jobs in ETL folder at once by right clicking on it and then build job. What's next to go for on Mac ?
Or, is there any way to schedule these exported job to run at particular on our server or cloud ?
If so please let me know the steps to perform.
Based on your explanation, I will consider that your ExtractVendors job is the main master job. Hence, you only need to right click on ExtractVendors and Build the Job. This will produce a zip file.
You can copy the zip file anywhere, unzip it, and run the .sh script on a Mac/Linux or the .bat on Windows. For Mac, you will use the .sh script since it is Linux based.
Of course, you need Java JRE on the server where you are running it.
The Talend Administration Center (Subscription based) has scheduler capabilities to execute your jobs.