topic Re: Schedule a task for hourly replication in Qlik Replicate

Schedule a task for hourly replication

srahul — Thu, 04 May 2023 15:14:44 GMT

How to schedule a task for hourly replication in Qlik Replicate?

Re: Schedule a task for hourly replication

PGN — Thu, 04 May 2023 15:24:39 GMT

We've done this creatively by scheduling it via Task Scheduler on the app server. Example:

D:\attunity\replicate\bin\repctl.exe -d E:\data connect; execute [taskname] 1 Flags=1; disconnect

Re: Schedule a task for hourly replication

Alan_Wang — Thu, 04 May 2023 15:39:02 GMT

Hi @srahul

There's no hourly option for the scheduler so you will need to make 24 different scheduled jobs to run at the top of the specific hour or create some custom scripts to execute APIs that will run one-time scheduled jobs on an hourly basis.

Re: Schedule a task for hourly replication

Heinvandenheuvel — Thu, 04 May 2023 18:11:45 GMT

There IS an hourly option, it is just not available through the GUI.

If you do an exportrepository, what do you see? you might see: "schedule": "0 17 * * * *",

What does that look like? Yes! A CRON job schedule string. Those are well documented for example in : https://cloud.google.com/scheduler/docs/configuring/cron-job-schedules

So for every hour you can edit the JSON and indicate 0 0-24 * * * * for every 2 hours 0 */2 * * * *

For a quick 'trust but verify' test I tested every 2 minutes both using 31,33,35,37 * * * * * and 0/2 * * * * *

Works fine! After importrepository with the desired schedule I did have to un-schedule a job, save, reschedule and save again to 'activate' the recently imported schedules.

Btw... the arguments in the "execute_req" section for the scheduler match the REPCTL EXECUTE arguments, should you ever feel the desire to experiment with that. (see below)

Hein.

C:\scripts>repctl execute ? command execute: request arguments: task:required string operation:required enum, valid values: 01 - EXECUTE_OPERATIONS_LOAD 02 - EXECUTE_OPERATIONS_CDC 03 - EXECUTE_OPERATIONS_BOTH flags:optional enum, valid values: 00 - RESUME 01 - FRESH 02 - METADATA_ONLY 03 - FRESH_METADATA_ONLY 04 - COLLECTION 08 - RECOVERY 16 - DIAAS 17 - FRESH_DIAAS

Re: Schedule a task for hourly replication

nareshkumar — Wed, 09 Oct 2024 21:06:21 GMT

I tried with REST API #

Token for REST API:

[qlikappq@XXX-uvlqlkq01 ~]$ echo -n '529300@tmm:TamyaXXXXXX' | base64

GBD9gNYDx5ayfgNM0o_GIB

And with following command I am able to run the Job successfully :

curl -i -k -X POST --header "EnterpriseManager.APISessionID: GBD9gNYDx5ayfgNM0o_GIB" --header "Content-Length: 0" https://server.com/attunityenterprisemanager/api/v1/servers/DDC_QA_SERVER/tasks/NPPS_AS400_PR_SRC_PG_Tgt_FULL?action=run"&"option=RELOAD_TARGET