Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I'm using QV 11 SR12 and I would like to have list of jobs running ?
Do you where I can get the information ?
I'm using XML files to save publisher configuration
I have tried to read all xml files in folder TaskExecution History but it was working yesterday and today I can't get the same list all jobs in xml files are with status "completed" and I have like 10 jobs running
Thanks
Adrien
Ok in fact it's working
LOAD TaskId as Debug_TaskRunningId
FROM [$(_DistributionLogFolder)\TaskExecutionHistory\TaskExecutionHistory_*.xml] (XmlSimple, Table is [Root/TaskExecutionHistoryItems/TaskExecutionHistoryItem])
where TaskStatus = 'Running'
and left(StartTimeStamp, 10) = date(today(), 'DD/MM/YYYY')
;
Ok in fact it's working
LOAD TaskId as Debug_TaskRunningId
FROM [$(_DistributionLogFolder)\TaskExecutionHistory\TaskExecutionHistory_*.xml] (XmlSimple, Table is [Root/TaskExecutionHistoryItems/TaskExecutionHistoryItem])
where TaskStatus = 'Running'
and left(StartTimeStamp, 10) = date(today(), 'DD/MM/YYYY')
;