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 ' ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings
