DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=message-id:date:from:to:subject:mime-version:content-type;
	b=mZFyT+IKN9uhoGh9Q7j/bAw7sLwboBzxoXJrIfgWTzlgfF9eYhbbJ1CoM4Ymo0eCg6
	0c25buhs/gI422lIJVVqN0vEvZS6Rw4/JynVVmz6T6NCicI8FaKXXsyEkf7usXXIUbkN
	gIhJcs0qo+kC9tBSKsAZy0bMsF/JLHQXfDFcI=
Message-ID: <f0c828c40807151054m23da67ecm9ff3ea818bd59fc1@mail.gmail.com>
Date: Tue, 15 Jul 2008 13:54:00 -0400
From: "samantha mahindrakar" <sam.mahindrakar@gmail.com>
To: pgsql-admin@postgresql.org
Subject: Jobs using pgagent
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_Part_9519_10126292.1216144440319"

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

Hi....
Iam using postgres since recently.....there are jobs scheduled using the
pgagent. There are loaders and stuff that are scheduled using the pgagent.
There is a new job that i have added............the weird part is that it
runs for different amounts of time everyday. For example: it has run for
3hours,5 hours on some days and for 16hours on some days. It processing
equally amounts of data on each of these days.
When i look at the log file............the RAISE NOTICE statements are not
continous .........i.e. statements of other DB processes are printed and
then the statements of the program are printed............seems like its
running on and off. As far my knowledge goes pgagent can handle parallel
jobs.
Though i see locks made by the program............iam not sure if thats the
problem. Can someone give me a pointer on this?

Thanks
Sam

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

<div>Hi....</div>
<div>Iam using postgres since recently.....there are jobs&nbsp;scheduled&nbsp;using the pgagent. There are loaders and stuff that are scheduled using the pgagent. There is a new job that i have added............the weird part is that it runs for different amounts of time everyday. For example: it has run for 3hours,5 hours on some days and for 16hours on some days. It processing equally amounts of data on each of these days. </div>

<div>When i look at the log file............the RAISE NOTICE statements are not continous .........i.e. statements of other DB processes are printed and then the statements of the program are printed............seems like its running on and off. As far my knowledge goes pgagent can handle parallel jobs.</div>

<div>Though i see locks made by the program............iam not sure if thats the problem. Can someone give me a pointer on this?</div>
<div>&nbsp;</div>
<div>Thanks</div>
<div>Sam</div>

------=_Part_9519_10126292.1216144440319--