QUERY CURRENT STEP

2796
3
08-26-2010 09:01 PM
Ulises
by
Occasional Contributor III
Is there any way to query current steps in a job and who has it assigned???  I want to generate a report that show the user, job_id, current step, and dates.  The idea is to allow managers to track daily progress (ex. who is not achieving the daily cuota).  We have version 3.0.1. 

Thanks
Ulises Feliciano Troche
0 Kudos
3 Replies
AndrewMcColgan
New Contributor
I'm using version 9.3.1, but was able to get what you are looking for using the attached job query.

-Andrew McColgan
Computer Software Specialist
Memphis Light, Gas, and Water
0 Kudos
Ulises
by
Occasional Contributor III
Thanks Andrew...it works nicely.  But is there a way to export the job history to a file?  I'm trying to create a report outside of JTX...
Ulises Feliciano Troche
0 Kudos
BrianDemers
Esri Contributor
Hi,

Even at version 10, I don't know of an out-of-the-box way to export job history to a file.  However, job history is stored in the "JTX_HISTORY" table so there may be some options...

If you'll be exporting the job history frequently and you're familiar with Python, you could write a Python script to extract the information from the JTX_HISTORY table for a given job and save it to a text file.  From what you describe, that's probably the best immediate solution.

Alternatively -- admittedly, this probably isn't viable if these are daily reports -- you could use ArcCatalog to copy/export the JTX_HISTORY table to another format.  For instance, export it to a .dbf file then open the .dbf in Microsoft Excel, or copy the table into a Personal Geodatabase then view the pGDB with Microsoft Access.  From Excel or Access, you could presumably convert the data yet again.

One last idea: if/when you're able to upgrade to a newer release, you could look into setting up a Workflow Manager web application (downloadable from the resource center).  Using ArcGIS Server and Workflow Manager Server, these apps make it possible to view job information over the web.  (It sounds like this "track jobs without everyone installing Workflow Manager" may be what you're really looking to do?)

Good luck!

Brian D.
0 Kudos