I have successfully compiled pgagent from source on a CentOS 6.2 server.
When I try to launch pgagent with the following command :
/usr/bin/pgagent -l 2 hostaddr=serveur.com dbname=postgres user=postgres
I get the following error messages :
DEBUG: …
I am trying to install pgAgent for two straight day on a centOS 6.2 64bit.
I have been trying to compile it from source without success because I could not manage to compile wxWidgets.
I have been trying to use a precompiled version but was…
I wanted to install pgAgent service on windows. Though it installs alright using the following command:
C:\Program Files (x86)\pgAdmin III\1.14>pgagent.exe INSTALL pgAgent -l2 -u postgres hostaddr=localhost port=5432 dbname=postgres…
We know that there is SQL Server Agent, functions as Job Scheduler, in MSSQL. If we want to manage jobs on Server Agent, with a C#/.NET application, we can use Microsoft.SqlServer.Management.Smo library and start a connection between two (SQL Server…
Could someone tells me what is wrong please.
I try to create a job with using PgAgent with declaring some variables. When I run this code manually, it works successfully. But when I try to put this code in job step and save it, it throws me an…
I am pretty new to postgresql and not able to understand what the following query does, so want help of some communuty memebers who can explain me this to me.
DO $$
DECLARE
jid integer;
scid integer;
BEGIN
-- Creating a new job
INSERT INTO…
I'm trying to schedule a job using pgAgent in postgresql.
pgAgent is working fine with the postgres database, but when i'm selecting the other database which i created. It is not working, the job is getting failed.
Can someone guide me in…
