SVN Commit by dpage: r4187 - trunk/pgadmin3/xtra/pgagent

Author: dpage
Date: 2005-05-17 14:32:25 +0100 (Tue, 17 May 2005)
New Revision: 4187

Modified:
   trunk/pgadmin3/xtra/pgagent/pgagent.sql
Log:
Oops, couple of objects missing.

Modified: trunk/pgadmin3/xtra/pgagent/pgagent.sql
===================================================================
--- trunk/pgadmin3/xtra/pgagent/pgagent.sql    2005-05-17 06:57:26 UTC (rev 4186)
+++ trunk/pgadmin3/xtra/pgagent/pgagent.sql    2005-05-17 13:32:25 UTC (rev 4187)
@@ -551,12 +551,30 @@
 COMMENT ON FUNCTION pgagent.pga_is_leap_year(int2) IS 'Returns TRUE is $1 is a leap year';


-/*
-!!! not yet implemented?
+CREATE OR REPLACE FUNCTION pgagent.pga_job_trigger()
+  RETURNS "trigger" AS
+$BODY$
+BEGIN
+    IF NEW.jobenabled THEN
+        IF NEW.jobnextrun IS NULL THEN
+             SELECT INTO NEW.jobnextrun
+                    MIN(pgagent.pga_next_schedule(jscid, jscstart, jscend, jscminutes, jschours, jscweekdays,
jscmonthdays,jscmonths)) 
+               FROM pgagent.pga_schedule
+              WHERE jscenabled AND jscjobid=OLD.jobid;
+        END IF;
+    ELSE
+        NEW.jobnextrun := NULL;
+    END IF;
+    RETURN NEW;
+END;
+$BODY$
+  LANGUAGE 'plpgsql' VOLATILE;
+COMMENT ON FUNCTION pgagent.pga_job_trigger() IS 'Update the job''s next run time.';
+
 CREATE TRIGGER pga_job_trigger BEFORE UPDATE
-   ON pgagent.pga_job FOR EACH ROW
-   EXECUTE PROCEDURE pgagent.pga_job_trigger();
-*/
+  ON pgagent.pga_job FOR EACH ROW
+  EXECUTE PROCEDURE pgagent.pga_job_trigger();
+COMMENT ON TRIGGER pga_job_trigger ON pgagent.pga_job IS 'Update the job''s next run time.';


 CREATE OR REPLACE FUNCTION pgagent.pga_schedule_trigger() RETURNS trigger AS '