Yes. Its working fine.
What i mean i created function to delete parts from table.Then i need to place it on pgagent.
i placed function in pagent
like this..
do $$
declare
job_id int;
begin
/* add a job and get its id: */
insert into
pgagent.pga_job (jobjclid, jobname)
values
(1 /*1=Routine Maintenance*/, 'part delete')
returning
jobid
into
job_id;
/* add a step to the job: */
insert into
pgagent.pga_jobstep (jstjobid, jstname, jstkind, jstcode, jstdbname)
values
( job_id,
'my step name',
's', /* sql step */
'do
$BODY$
BEGIN
perform delete_empty_parts();
end;
$BODY$', /* the sql to run */
'sakila' /* the name of the database to run the step against */
);
/* add a schedule to the job. This one runs every minute: */
insert into
pgagent.pga_schedule (jscjobid, jscname)
values
(job_id, 'my schedule name');
end $$;
it sprogramatic way..
excuted fine.where i need to find this job.Jobs section..?,if yes unable to see the job after excuted..please let me know where i need to excute and where it is place..
2.is their any chance place function in pgagent directly in diagramatic way ..?
like right click on job create job..
i think step-->defintion..
how to place it and can i select sql or batch..?
On Fri, Apr 3, 2015 at 3:50 PM, <pgsql-general-owner@xxxxxxxxxxxxxx> wrote:
Your message to pgsql-general has been delayed, and requires the approval
of the moderators, for the following reason(s):
The author (Ramesh T <rameshparnanditech@xxxxxxxxx>)
is not a member of any of the restrict_post groups.
If you do not wish the message to be posted, or have other concerns,
please send a message to the list owners at the following address:
pgsql-general-owner@xxxxxxxxxxxxxx
---------- Forwarded message ----------
From: Ramesh T <rameshparnanditech@xxxxxxxxx>
To: Pavel Stehule <pavel.stehule@xxxxxxxxx>, "pgsql-general@xxxxxxxxxxxxxx" <pgsql-general@xxxxxxxxxxxxxx>
Cc:
Date: Fri, 3 Apr 2015 15:50:43 +0530
Subject: Re:The link is good.But What I am expecting the following link..Created Using pgAgent.in above link process they placed location of the script file at STEP DEFINTION TAB creation process..same way is there a chance to place creation of table or delete statements in pgAgent process..?my aim to create job is delete some null data from table dailyOn Fri, Apr 3, 2015 at 3:30 PM, Pavel Stehule <pavel.stehule@xxxxxxxxx> wrote:Pavel StehuleHiregards
http://stackoverflow.com/questions/4477301/creating-jobs-and-schedules-programatically-with-pgagent2015-04-03 11:27 GMT+02:00 Ramesh T <rameshparnanditech@xxxxxxxxx>:Hi ,How to create job in pgAgent.Where I need to place script in pgAgent..any helpAdvanced thanks...
