[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-sql
Subject:    Re: [SQL] [ADMIN] Scheduled Events
From:       Marcin Krawczyk <jankes.mk () gmail ! com>
Date:       2013-12-17 12:06:38
Message-ID: CABnqL32yqvwdpyct6aPv9h_xwf3NpkqcCbS2qJjtc44_5aUqsQ () mail ! gmail ! com
[Download RAW message or body]

I'm using pgAgent you mentioned before. You can easily schedule recurring
tasks from within pgAdmin.

regards
mk


2013/12/11 Dev Kumkar <devdas.kumkar@gmail.com>

> Resending...
>
> On Wed, Dec 11, 2013 at 8:29 PM, Dev Kumkar <devdas.kumkar@gmail.com>wrote:
>
>> Yes actually that's one alternate solution to use cron or windows
>> scheduled tasks.
>>
>> The intent is to call certain stored procedures at certain time intervals.
>>
>>
>> On Wed, Dec 11, 2013 at 7:24 PM, Payal Singh <payal@omniti.com> wrote:
>>
>>> You can schedule those jobs in a crontab. If it is a SQL command, you
>>> can use  the -c option with psql.
>>>
>>>
>>> On Wed, Dec 11, 2013 at 05:08:12PM +0530, Dev Kumkar wrote:
>>> > How to create scheduled events in postgres simillar to whats event in
>>> > Sybase.
>>> > Is there any method of doing so?
>>> >
>>> > Also am looking at PgAgent which can create jobs but is it similar like
>>> > events in sybase.
>>> >
>>> > Please suggest.
>>> >
>>> > Regards...
>>>
>>

[Attachment #3 (text/html)]

<div dir="ltr">I&#39;m using pgAgent you mentioned before. You can easily schedule \
recurring tasks from within pgAdmin.<div class="gmail_extra"><br \
clear="all"><div>regards<br>mk</div> <br><br><div class="gmail_quote">2013/12/11 Dev \
Kumkar <span dir="ltr">&lt;<a href="mailto:devdas.kumkar@gmail.com" \
target="_blank">devdas.kumkar@gmail.com</a>&gt;</span><br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">

<div dir="ltr"><div class="gmail_extra"><div \
class="gmail_quote">Resending...<br><br>On Wed, Dec 11, 2013 at 8:29 PM, Dev Kumkar \
<span dir="ltr">&lt;<a href="mailto:devdas.kumkar@gmail.com" \
target="_blank">devdas.kumkar@gmail.com</a>&gt;</span> wrote:<br>


<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex"><div dir="ltr"><div>Yes actually that&#39;s one alternate \
solution to use cron or windows scheduled tasks.<br><br></div>


The intent is to call certain stored procedures at certain time \
intervals.<br></div><div class="gmail_extra"><div><div> <br><br><div \
class="gmail_quote">On Wed, Dec 11, 2013 at 7:24 PM, Payal Singh <span \
dir="ltr">&lt;<a href="mailto:payal@omniti.com" \
target="_blank">payal@omniti.com</a>&gt;</span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc \
solid;padding-left:1ex">



You can schedule those jobs in a crontab. If it is a SQL command, you can use  the -c \
option with psql.<div><div class="h5"><br> <div><div><br>
On Wed, Dec 11, 2013 at 05:08:12PM +0530, Dev Kumkar wrote:<br>
&gt; How to create scheduled events in postgres simillar to whats event in<br>
&gt; Sybase.<br>
&gt; Is there any method of doing so?<br>
&gt;<br>
&gt; Also am looking at PgAgent which can create jobs but is it similar like<br>
&gt; events in sybase.<br>
&gt;<br>
&gt; Please suggest.<br>
&gt;<br>
&gt; Regards...<br>
</div></div></div></div></blockquote></div></div></div></div></blockquote></div></div></div>
 </blockquote></div><br></div></div>



[prev in list] [next in list] [prev in thread] [next in thread]