Schedule a task for hourly replication

[srahul]

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

[PGN]

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

[Alan_Wang · Accepted solution]

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.

[Heinvandenheuvel]

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

[nareshkumar]

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...