Knowledge 360
Sunday 24 March 2024
How To Call A PostgreSQL Stored Procedure From pgAgent Schedule In pgAge...
Select * from jobs order by 1 desc;
delete from jobs;
CREATE OR REPLACE PROCEDURE public.job_proc()
LANGUAGE 'plpgsql'
AS $BODY$
DECLARE
BEGIN
Insert into jobs (entry_job) values (now());
END;
$BODY$;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment