Index: /trunk/ippTools/src/pstamptool.c
===================================================================
--- /trunk/ippTools/src/pstamptool.c	(revision 25053)
+++ /trunk/ippTools/src/pstamptool.c	(revision 25054)
@@ -496,5 +496,4 @@
 {
     bool    stampJob = false;
-    char   *query = NULL;
 
     PS_ASSERT_PTR_NON_NULL(config, false);
@@ -503,8 +502,14 @@
     PXOPT_LOOKUP_STR(rownum,      config->args, "-rownum",     true, false);
     PXOPT_LOOKUP_STR(job_type,    config->args, "-job_type",   false, false);
-    PXOPT_LOOKUP_STR(outputBase,  config->args, "-outputBase", true,  false);
+    PXOPT_LOOKUP_STR(outputBase,  config->args, "-outputBase", false,  false);
     PXOPT_LOOKUP_STR(stateString, config->args, "-state",      false, false);
-    PXOPT_LOOKUP_STR(fault,       config->args, "-fault",      false, false);
+    PXOPT_LOOKUP_S16(fault,       config->args, "-fault",      false, false);
     PXOPT_LOOKUP_S64(exp_id,      config->args, "-exp_id",     false, false);
+
+    // unless the job is being inserted with stop state require outputBase
+    if (strcmp(stateString, "stop") && !outputBase) {
+	psError(PS_ERR_UNKNOWN, true, "-outputBase is required");
+	return false;
+    }
 
     // default value for job_type is defined in pstamptoolConfig.c
@@ -517,15 +522,14 @@
 	return false;
     }
-    if (stampJob) {
-	query = pxDataGet("pstamptool_addjob_stampjob.sql");
-    } else {
-	query = pxDataGet("pstamptool_addjob_otherjob.sql");
-    }
-    if (!query) {
-        psError(PXTOOLS_ERR_DATA, false, "failed to retreive SQL statement");
-        return false;
-    }
-
-    if (!p_psDBRunQueryF(config->dbh, query, req_id, rownum, stateString, job_type, exp_id, outputBase, fault)) {
+    if (!pstampJobInsert(config->dbh, 
+            0, // job_id
+            req_id,
+            rownum, 
+            stateString, 
+            job_type, 
+            fault, 
+            exp_id, 
+            outputBase
+            )) {
         psError(PS_ERR_UNKNOWN, false, "database error");
         return false;
Index: /trunk/ippTools/src/pstamptoolConfig.c
===================================================================
--- /trunk/ippTools/src/pstamptoolConfig.c	(revision 25053)
+++ /trunk/ippTools/src/pstamptoolConfig.c	(revision 25054)
@@ -106,5 +106,5 @@
     psMetadataAddStr(addjobArgs, PS_LIST_TAIL, "-state", 0,            "new state", "run"); 
     psMetadataAddS64(addjobArgs, PS_LIST_TAIL, "-exp_id", 0,           "exposure id", 0); 
-    psMetadataAddStr(addjobArgs, PS_LIST_TAIL, "-fault", 0,            "new result", NULL); 
+    psMetadataAddS16(addjobArgs, PS_LIST_TAIL, "-fault", 0,            "new result", 0); 
 
     // -listjob