topic Scheduling SQL script in Replicate in Qlik Replicate

Scheduling SQL script in Replicate

sardarabdullahkhawar — Sun, 07 Jan 2024 06:56:44 GMT

Hi all,

hope you guys are doing well. Is it possible schedule custom SQL script in Qlik Replicate?

Re: Scheduling SQL script in Replicate

john_wang — Sun, 07 Jan 2024 08:50:05 GMT

Thanks for reaching out to Qlik Community!

Please elaborate on your proposals a little, eg what's the SQL purpose and where is it being executed (at source or target database) and why run it repeatedly (for example schedule it etc). In general it's no however we'd like to understand further to see if any alternative options for you.

Regards,

John.

Re: Scheduling SQL script in Replicate

sardarabdullahkhawar — Sun, 07 Jan 2024 09:31:41 GMT

Thanks John,

Actually i want to run stored procedure in Qlik Replicate and then schedule it daily maybe. I know it can be done in Qlik Compose but i want to use scheduling capability of Qlik Replicate.

Re: Scheduling SQL script in Replicate

john_wang — Mon, 08 Jan 2024 01:15:47 GMT

Hello @sardarabdullahkhawar ,

Thanks for the update.

We may use the Qlik Replicate Scheduler to schedule a one-time job or a recurrent job for specific Replicate task operation (not a Compose task).

Hope this helps.

John.