Hey,
After viewing another forum post http://forums.thinkboxsoftware.com/viewtopic.php?f=11&t=11376 I was interested in poking around the DeadlineDB databases to see what kind of information I could gather. After digging through the Job collection, I found a key/value pair that interested me for figuring out job statuses.
[ ... ]
'ExDic' =>
array (size=0)
empty
'QueuedChunks' => int 0
'RenderingChunks' => int 0
'Stat' => int 6
'SuspendedChunks' => int 0
[ ... ]
I was curious what range of values ‘Stat’ would hold? So far I’ve come up with:
1 = rendering
2 = suspended
3 = completed
4 = failed
5 = ?
6 = pendingI haven’t been able to locate any "Stat"s with a value of 5, and it looks like Queued jobs as well as Rendering jobs contain a value of 1. I was originally using this to differentiate which jobs were rendering and which ones were queued, but found that either will report the same “Stat”. I had to dig deeper and base my conclusion if a job was either queued or rendering by looking at the QueuedChunks and RenderingChunks keys additionally.
All of this information will be used to tap into Deadline from a PHP webpage or from Python modules to quickly display render farm overviews for whatever criteria a user is looking for. This would be helpful to those in the Production departments.