From: | svn(at)pgadmin(dot)org |
---|---|
To: | pgadmin-hackers(at)postgresql(dot)org |
Subject: | SVN Commit by dpage: r4187 - trunk/pgadmin3/xtra/pgagent |
Date: | 2005-05-17 13:32:25 |
Message-ID: | 200505171332.j4HDWPGq010787@developer.pgadmin.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-hackers |
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 '
From | Date | Subject | |
---|---|---|---|
Next Message | svn | 2005-05-17 13:53:30 | SVN Commit by dpage: r4188 - trunk/pgadmin3/xtra/pgagent |
Previous Message | svn | 2005-05-17 06:57:26 | SVN Commit by dpage: r4186 - trunk/pgadmin3/xtra/pgagent |