Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have 3 failed tasks as showing the picture, but the marked task is interesting.
I made a request to:
/qrs/task/full?xrfkey=1234567891234567&filter=id+eq+9b9f830f-41dc-4ba1-9313-2417e2882981+and+operational.lastExecutionResult.status+eq+8+and+enabled+eq+true
This Id is associated to the task "Target Email Sends" and the result was:
[ { "id": "9b9f830f-41dc-4ba1-9313-2417e2882981", "createdDate": "2018-08-02T15:07:18.429Z", "modifiedDate": "2018-10-31T04:15:40.833Z", "modifiedByUserName": "TONY\\main", "customProperties": [], "app": { "id": "074408c4-7217-4382-9904-7edb6130d746", "name": "Target - Email Sends", "appId": "", "publishTime": "2018-07-31T19:15:51.420Z", "published": true, "stream": { "id": "1e2224e8-fa38-4685-b617-47d7650d9327", "name": "publics", "privileges": null }, "savedInProductVersion": "12.145.4", "migrationHash": "98d482c3f964dccf69cbfb9a00e0c048ea6eb221", "availabilityStatus": 0, "privileges": null }, "isManuallyTriggered": false, "operational": { "id": "21e609ea-06df-425a-b81a-0cf66559964e", "lastExecutionResult": { "id": "f97eb3fa-ec5b-4f8a-87d2-e2bb50b19899", "executingNodeName": "qlik-node2.ad.TONY.com", "status": 8, "startTime": "2018-12-04T04:30:54.053Z", "stopTime": "2018-12-04T04:31:23.959Z", "duration": 29906, "fileReferenceID": "b14bf6b9-c6a9-46ba-bfeb-2640e54276d0", "scriptLogAvailable": false, "details": [ { "id": "3db3be1f-af89-41d8-b5a7-6e71586d5f48", "detailsType": 2, "message": "Trying to start task. Sending task to slave scheduler qlik-node2.ad.TONY.com", "detailCreatedDate": "2018-12-04T04:30:54.272Z", "privileges": null }, { "id": "31430c31-d8bb-4526-a736-c0802c49516b", "detailsType": 2, "message": "Changing task state from Triggered to Started", "detailCreatedDate": "2018-12-04T04:30:54.412Z", "privileges": null } ], "privileges": null }, "nextExecution": "2018-12-05T04:30:54.000Z", "privileges": null }, "name": "T ", "taskType": 0, "enabled": true, "taskSessionTimeout": 1440, "maxRetries": 0, "tags": [], "privileges": null, "schemaPath": "ReloadTask" } ]
In the picture appear 2018-12-03 23:30 (yesterday almost midnight) but in the response to the QRS API "lastExecutionResult" in "operational" block has as "startTime" "2018-12-04T04:30:54.053Z" .
Then, how can I know the last date of execution of the task? and that is equal to the one shown by Qlik in its dashboard.
The time is stored as UTC without timezone off-set.
Example from my end:
{ "id": "bc193abd-707f-4dfc-b33b-0f4b3d9bc877", "createdDate": "2018-10-04T16:22:31.404Z", "modifiedDate": "2018-10-04T16:22:31.404Z", "modifiedByUserName": "DOMAIN\\USERID", "customProperties": [], "app": { "id": "6e794c0a-6913-4179-ab17-06b8a5f1c8f7", "name": "Random Data", "appId": "", "publishTime": "2018-06-28T19:04:06.06Z", "published": true, "stream": { "id": "aaec8d41-5201-43ab-809f-3063750dfafd", "name": "Everyone", "privileges": null }, "savedInProductVersion": "12.244.5", "migrationHash": "98d482c3f964dccf69cbfb9a00e0c048ea6eb221", "availabilityStatus": 0, "privileges": null }, "isManuallyTriggered": false, "operational": { "id": "48e96c6e-f574-4763-894c-d9e21cd34576", "lastExecutionResult": { "id": "561077b8-97ce-42a7-be3a-ef1cf3f94dae", "executingNodeName": "Sense.Company.com", "status": 7, "startTime": "2018-12-04T21:16:02.355Z", "stopTime": "2018-12-04T21:16:13.901Z", "duration": 11546, "fileReferenceID": "c14f8314-aa22-4185-b363-d6d52cb6ff6a", "scriptLogAvailable": false, "privileges": null }, "nextExecution": "1753-01-01T00:00:00Z", "privileges": null }, "name": "foo1", "taskType": 0, "enabled": true, "taskSessionTimeout": 1440, "maxRetries": 0, "tags": [], "privileges": null, "schemaPath": "ReloadTask" }
The key times for the task (operational) is:
The local time would be 4:16PM EST. Translating that into 24 hour format, would be 16:14. And since I am EST, I am -5 off-set to UTC so it now becomes 21:16.
Make sense?
The time is stored as UTC without timezone off-set.
Example from my end:
{ "id": "bc193abd-707f-4dfc-b33b-0f4b3d9bc877", "createdDate": "2018-10-04T16:22:31.404Z", "modifiedDate": "2018-10-04T16:22:31.404Z", "modifiedByUserName": "DOMAIN\\USERID", "customProperties": [], "app": { "id": "6e794c0a-6913-4179-ab17-06b8a5f1c8f7", "name": "Random Data", "appId": "", "publishTime": "2018-06-28T19:04:06.06Z", "published": true, "stream": { "id": "aaec8d41-5201-43ab-809f-3063750dfafd", "name": "Everyone", "privileges": null }, "savedInProductVersion": "12.244.5", "migrationHash": "98d482c3f964dccf69cbfb9a00e0c048ea6eb221", "availabilityStatus": 0, "privileges": null }, "isManuallyTriggered": false, "operational": { "id": "48e96c6e-f574-4763-894c-d9e21cd34576", "lastExecutionResult": { "id": "561077b8-97ce-42a7-be3a-ef1cf3f94dae", "executingNodeName": "Sense.Company.com", "status": 7, "startTime": "2018-12-04T21:16:02.355Z", "stopTime": "2018-12-04T21:16:13.901Z", "duration": 11546, "fileReferenceID": "c14f8314-aa22-4185-b363-d6d52cb6ff6a", "scriptLogAvailable": false, "privileges": null }, "nextExecution": "1753-01-01T00:00:00Z", "privileges": null }, "name": "foo1", "taskType": 0, "enabled": true, "taskSessionTimeout": 1440, "maxRetries": 0, "tags": [], "privileges": null, "schemaPath": "ReloadTask" }
The key times for the task (operational) is:
The local time would be 4:16PM EST. Translating that into 24 hour format, would be 16:14. And since I am EST, I am -5 off-set to UTC so it now becomes 21:16.
Make sense?