Index: trunk/ippTools/share/Makefile.am
===================================================================
--- trunk/ippTools/share/Makefile.am	(revision 25674)
+++ trunk/ippTools/share/Makefile.am	(revision 25711)
@@ -195,4 +195,5 @@
      pstamptool_completedreq.sql \
      pstamptool_datastore.sql \
+     pstamptool_listjob.sql \
      pstamptool_pendingjob.sql \
      pstamptool_pendingreq.sql \
Index: trunk/ippTools/share/pstamptool_listjob.sql
===================================================================
--- trunk/ippTools/share/pstamptool_listjob.sql	(revision 25711)
+++ trunk/ippTools/share/pstamptool_listjob.sql	(revision 25711)
@@ -0,0 +1,6 @@
+SELECT
+    pstampJob.*,
+    pstampRequest.name,
+    pstampRequest.outProduct
+FROM pstampJob
+    JOIN pstampRequest USING(req_id)
Index: trunk/ippTools/share/pxadmin_create_tables.sql
===================================================================
--- trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25674)
+++ trunk/ippTools/share/pxadmin_create_tables.sql	(revision 25711)
@@ -1249,4 +1249,5 @@
         exp_id BIGINT,
         outputBase VARCHAR(255),
+        options BIGINT,
         PRIMARY KEY(job_id, req_id),
         KEY(job_id),
