Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Get lists jobs running

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

1 Solution

Accepted Solutions
Not applicable
Author

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')

;

View solution in original post

1 Reply
Not applicable
Author

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')

;