<div class="WordSection1"><p class="MsoNormal">Hi There,<p class="MsoNormal"> <p class="MsoNormal">We are using PGAgent
forscheduling a job which is calling a batch program.(.sh)<p class="MsoNormal"> <p class="MsoNormal">The logic of the
batchprogram is to : Reload the postgres setting by using pg_ctl reload command.<p class="MsoNormal"> <p
class="MsoNormal">Batchprogram when run from the command prompt is causing the POSTGRES server setting reloaded (i.e
SIGHUPsignal is sent to the server).<p class="MsoNormal"> <p class="MsoNormal">However when I include the same program
inthe Job step and run the Job from PGAgent, the job status is shown as ‘Successful’ in the ‘status’ window for the
PGagentjob but the SIGHUP signal is not sent to the server (This I verified by checking the POSTGRES server log which
logsa message when a SIGHUP signal is sent to the server for reloading the settings, but in this case, no such message
isbeing written to the server log).<p class="MsoNormal"> <p class="MsoNormal"><b><u>Issue:</u></b><p
class="MsoNormal"><b> </b><pclass="MsoNormal"><span style="background:yellow;mso-highlight:yellow">Can you please let
meknow if PGAgent logs any errors if there are any issues with the jobs executed.. Why is the job status shown as
‘Successful’even though nothing happened.</span><p class="MsoNormal"> <p class="MsoNormal">The details of the
environmentwith which errors are logged are :<p class="MsoNormal"> <p class="MsoNormal">PGAgent version :
pgAgent-3.0.0<pclass="MsoNormal">PGAdmin : 1.12.1<p class="MsoNormal">PostgreSQL : 8.3<p class="MsoNormal"> <p
class="MsoNormal">Thanks<pclass="MsoNormal">Jahnavi<p class="MsoNormal"> </div><br /><hr /><font color="Gray"
face="Arial"size="1">DISCLAIMER:<br /><br /> This email may contain confidential information and is intended only for
theuse of the specific individual(s) to which it is addressed. If you are not the intended recipient of this email, you
arehereby notified that any unauthorized use, dissemination or copying of this email or the information contained in it
orattached to it is strictly prohibited. If you received this message in error, please immediately notify the sender at
Infotechor Mail.Admin@infotech-enterprises.com and delete the original message.<br /></font>