i need to find the work items which is available longer than 10 mins in the quque....
is there any code availble for that.
Please guide me
This topic has been locked.
Pinned topic Find work items
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
drdamour 0600029F9D40 Posts
Re: Find work items2012-07-31T19:20:04ZThis is the accepted answer. This is the accepted answer.You want to query the queues using F_EnqueueTime as part of your filter clause
time types are stored as epoch int's so you have to use the function for the given DB type. IE GETDATE() for SQL server alas;
F_EnqueueTime > DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) - 60*10
would be anything in there longer than 10 minutes
different dbs are different statements, http://www.epochconverter.com/ is a good resource
I am Just a new Boy,
A Stranger in this Town,
Where are All the Good Times,
Who's Gonna Show this Stranger Around?
Check out our Agile ACM Catalogue: Widgets, APIs, & Components for Building Solutions