Author: dpage
Date: 2005-05-19 10:27:24 +0100 (Thu, 19 May 2005)
New Revision: 4214
Modified:
trunk/pgadmin3/xtra/pgagent/job.cpp
trunk/pgadmin3/xtra/pgagent/pgagent.sql
Log:
Rename jslstarted -> jslstart for consistency
Modified: trunk/pgadmin3/xtra/pgagent/job.cpp
===================================================================
--- trunk/pgadmin3/xtra/pgagent/job.cpp 2005-05-19 08:31:32 UTC (rev 4213)
+++ trunk/pgadmin3/xtra/pgagent/job.cpp 2005-05-19 09:27:24 UTC (rev 4214)
@@ -144,7 +144,7 @@
rc=serviceConn->ExecuteVoid(
"UPDATE pgagent.pga_jobsteplog "
- " SET jslduration = now() - jslstarted, "
+ " SET jslduration = now() - jslstart, "
" jslresult = " + NumToStr(rc) + ", jslstatus = '" + stepstatus + "' "
" WHERE jslid=" + jpsid);
if (rc != 1 || stepstatus == "f")
Modified: trunk/pgadmin3/xtra/pgagent/pgagent.sql
===================================================================
--- trunk/pgadmin3/xtra/pgagent/pgagent.sql 2005-05-19 08:31:32 UTC (rev 4213)
+++ trunk/pgadmin3/xtra/pgagent/pgagent.sql 2005-05-19 09:27:24 UTC (rev 4214)
@@ -131,7 +131,7 @@
jslcode text NOT NULL,
jslstatus char NOT NULL CHECK (jslstatus IN ('r', 's', 'i', 'f')) DEFAULT 'r', -- running,
success,ignored, failed
jslresult int2 NULL,
-jslstarted timestamptz NOT NULL DEFAULT current_timestamp,
+jslstart timestamptz NOT NULL DEFAULT current_timestamp,
jslduration interval NULL
) WITHOUT OIDS;
CREATE INDEX pga_jobsteplog_jslid ON pgagent.pga_jobsteplog(jsljlgid);