No title

Started by Ramesh Tabout 11 years ago3 messagesgeneral
Jump to latest
#1Ramesh T
rameshparnanditech@gmail.com

Hi ,
How to create job in pgAgent.Where I need to place script in
pgAgent..any help

Advanced thanks...

#2Pavel Stehule
pavel.stehule@gmail.com
In reply to: Ramesh T (#1)
Re:

Hi

http://stackoverflow.com/questions/4477301/creating-jobs-and-schedules-programatically-with-pgagent

regards

Pavel Stehule

2015-04-03 11:27 GMT+02:00 Ramesh T <rameshparnanditech@gmail.com>:

Show quoted text

Hi ,
How to create job in pgAgent.Where I need to place script in
pgAgent..any help

Advanced thanks...

#3Ramesh T
rameshparnanditech@gmail.com
In reply to: Pavel Stehule (#2)
Re:

The link is good.

But What I am expecting the following link..Created Using pgAgent.
http://www.postgresonline.com/journal/archives/19-Setting-up-PgAgent-and-Doing-Scheduled-Backups.html

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 daily

On Fri, Apr 3, 2015 at 3:30 PM, Pavel Stehule <pavel.stehule@gmail.com>
wrote:

Show quoted text

Hi

http://stackoverflow.com/questions/4477301/creating-jobs-and-schedules-programatically-with-pgagent

regards

Pavel Stehule

2015-04-03 11:27 GMT+02:00 Ramesh T <rameshparnanditech@gmail.com>:

Hi ,
How to create job in pgAgent.Where I need to place script in
pgAgent..any help

Advanced thanks...