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.
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?)
