Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I am looking at migrating our QR schedules via pipelines for different environments. When I export out the QR server via api and look at the schedules; I see the schedules are set up like this:
{
"name": "DEV_S004_GCS_DLA",
"command_id": 25,
"schedule": "0 1 * * * *",
"command_requests": {
"cleanlogs_req": {
"server": {},
"task": {},
"fts": {}
},
"logfilerollover_req": {},
"execute_req": {
"task": "",
"operation": "EXECUTE_OPERATIONS_BOTH",
"flags": "FRESH"
},
"stoptask_req": {
"task": ""
}
},
"task": "DEV_T222_DL_LENDING_DLA",
"is_local_time": true
}
In the "schedule" section - it looks like a cron; but it has six variables instead of the expected five. Can you please inform me what these different variables mean?
Thanks Mark.
I worked it out after a bit of experimenting. It is "Year" for the once off runs in Qlik Replicate.
Eg:
{
"name": "Test",
"command_id": 25,
"schedule": "30 15 7 1 * 2026",
"command_requests": {
"cleanlogs_req": {
"server": {
},
"task": {
},
"fts": {
}
},
"logfilerollover_req": {
},
"execute_req": {
"task": "",
"operation": "EXECUTE_OPERATIONS_BOTH",
"flags": "FRESH"
},
"stoptask_req": {
"task": ""
}
},
"task": "EIT_T002_OB_RFSB_ACCT_02",
"enabled": false
}
Hi @Jon_Donker ,
Great question! I believe the schedule format you're seeing is a cron expression, but it uses the Quartz cron format rather than the standard Unix cron format. The key difference is that Quartz cron has 6 fields instead of 5, with seconds as the first field.
Here's the field breakdown:
So, for your example schedule "0 1 * * * *":
Full reference:
https://help.qlik.com/en-US/compose/December2024/Content/ComposeDWDL/Main/DW/Cron%20Format%20and%20E...
Hope this helps!
Regards,
Mark Costa
Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com
Thanks Mark.
I worked it out after a bit of experimenting. It is "Year" for the once off runs in Qlik Replicate.
Eg:
{
"name": "Test",
"command_id": 25,
"schedule": "30 15 7 1 * 2026",
"command_requests": {
"cleanlogs_req": {
"server": {
},
"task": {
},
"fts": {
}
},
"logfilerollover_req": {
},
"execute_req": {
"task": "",
"operation": "EXECUTE_OPERATIONS_BOTH",
"flags": "FRESH"
},
"stoptask_req": {
"task": ""
}
},
"task": "EIT_T002_OB_RFSB_ACCT_02",
"enabled": false
}
Great! Thanks for sharing @Jon_Donker .
I missed the right context of the question. It is on Qlik Replicate....... my bad.
I'll mark your answer as solution.
Thank you,
Mark Costa
Read more at Data Voyagers - datavoyagers.net
Follow me on my LinkedIn | Know IPC Global at ipc-global.com