Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Discover how organizations are unlocking new revenue streams: Watch here
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to schedule a job in Open Studio every X time?

Hi,

 

I'm trying to synchronize a database (MSSQL), how do I schedule a job for it to run, for example, every 24 or every week?

 

Thank you.

Labels (3)
3 Replies
Anonymous
Not applicable
Author

Get a scheduling tool and configure it to trigger your compiled job. 

To compile the job, right-click on your job and select "Build Job". Compile it to a zip and remember the path. Once compiled. unzip the file and you will find a .bat or .sh file. You would use that to run the job. Configure your scheduling tool to trigger that. You can configure this with the crontab on linux if you want as well.

Anonymous
Not applicable
Author

Hi,

 

     The first step you have to perform is to export the Talend jobs as standalone scripts.Please refer the help document from Talend for the steps.

 

https://help.talend.com/reader/ws5cD2ctjY_qVTcfoCBr2g/bUMpiZcRW_a60NYjR~IBXA

 

    Once the standalone scripts are ready, you can schedule the job using a scheduler (for example crontab) and it happens outside Talend. In the case of Integration Platform of Talend or Talend Cloud, Talend will provide the scheduling engine called Talend Administartion Console (in the case of Talend Cloud, it is Talend Management Console).

 

    If the answer has helped you, could you please mark the topic as resolved? Kudos are also welcome.

 

Warm Regards,

 

Nikhil Thampi

Anonymous
Not applicable
Author

@nthampi how exactly is this different to what I stated in my answer?