Received: from localhost (unknown [200.46.204.183])
	by postgresql.org (Postfix) with ESMTP id 3816464FD96
	for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 24 Oct 2008 18:00:05 -0300 (ADT)
Received: from postgresql.org ([200.46.204.86])
	by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024)
	with ESMTP id 24455-06 for <pgsql-admin-postgresql.org@postgresql.org>;
	Fri, 24 Oct 2008 18:00:02 -0300 (ADT)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from nf-out-0910.google.com (nf-out-0910.google.com
 [64.233.182.186])
	by postgresql.org (Postfix) with ESMTP id 3935564FD8E
	for <pgsql-admin@postgresql.org>; Fri, 24 Oct 2008 18:00:02 -0300 (ADT)
Received: by nf-out-0910.google.com with SMTP id c7so481428nfi.23
	for <pgsql-admin@postgresql.org>; Fri, 24 Oct 2008 14:00:00 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:received:received:message-id:date:from:to
	:subject:in-reply-to:mime-version:content-type:references;
	bh=Dmz2PXfQFN7IJIPz9KwOqzefguQL1jKTbtVF7YEVxTM=;
	b=aFXqt/LbRHlNhK7NC0lHAt/YSlse6bFI7jVPsic/OT1KzOXyCjt5WujMjzvaFmwkKz
	9CqLE3GDFa23Oyz9amm6Muy6hSJzZ07P7xSmVZcXGuB9PIraKngybkOE2h9uMUV4h11x
	KUAsl01DZNe3+BEL+wFS5bgqvm0CjdWwQC9CY=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:in-reply-to:mime-version
	:content-type:references;
	b=ev3ya7mFbgNRC8RYGMGu8RaZ0SHRGIJV8j0zCsvS4YuTIEvL/9fa3CNYBn8iuEw93h
	g5Dzti5HVdfC4wTADo+3qOSxfm9dQlGX3uKA6cqBiEwnsvVd5gbMi6pbWdy/GTsGapT9
	yU/09ONPdR+b+1B8NKRBwH5Db0tprsr62iFTc=
Received: by 10.210.21.13 with SMTP id 13mr2895475ebu.162.1224882000756;
	Fri, 24 Oct 2008 14:00:00 -0700 (PDT)
Received: by 10.210.134.13 with HTTP; Fri, 24 Oct 2008 14:00:00 -0700 (PDT)
Message-ID: <c3df65eb0810241400g28d175cfv3bc455fc64868f7b@mail.gmail.com>
Date: Fri, 24 Oct 2008 15:00:00 -0600
From: "Robert Young" <robbyoung21@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Re: pgadmin not processing scheduled jobs
In-Reply-To: <c3df65eb0810241342u5f91731aubfaf839fd8416b2b@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_12933_27343495.1224882000740"
References: <c3df65eb0810241342u5f91731aubfaf839fd8416b2b@mail.gmail.com>
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=0.903 tagged_above=0 required=5
	tests=HTML_MESSAGE=0.001, NORMAL_HTTP_TO_IP=0.001, URIBL_RHS_DOB=0.901
X-Spam-Level: 
X-Archive-Number: 200810/162
X-Sequence-Number: 30618

------=_Part_12933_27343495.1224882000740
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I've solved the issue.  pgagent.pga_job.jobhostagent must be blank.  Thanks
to this link http://forums.enterprisedb.com/posts/list/1419.page

Anyway, the docs say ... "optionally the hostname of a specific machine
running pgAgent, if this job should only run on that specific server. If
left empty, any server may run the job. This is not normally an issue for
SQL-only jobs, however any jobs with batch/shell steps may need to be
targetted to a specific server." ..., so why didn't it work when I specified
the host of 127.0.0.1 or localhost?

Thanks

------=_Part_12933_27343495.1224882000740
Content-Type: text/html; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
Content-Disposition: inline

I&#39;ve solved the issue.&nbsp; pgagent.pga_job.jobhostagent must be blank.&nbsp; Thanks to this link <a href="http://forums.enterprisedb.com/posts/list/1419.page">http://forums.enterprisedb.com/posts/list/1419.page</a><br><br>Anyway, the docs say ... &quot;optionally the hostname
of a specific machine running pgAgent, if this job should only run on
that specific server. If left empty, any server may run the job. This
is not normally an issue for SQL-only jobs, however any jobs with
batch/shell steps may need to be targetted to a specific server.&quot; ..., so why didn&#39;t it work when I specified the host of <a href="http://127.0.0.1">127.0.0.1</a> or localhost?<br><br>Thanks<br>

------=_Part_12933_27343495.1224882000740--