Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lU6H8-00054z-7Q for pgsql-admin@arkaria.postgresql.org; Wed, 07 Apr 2021 11:23:10 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.92) (envelope-from ) id 1lU6H7-00035Z-6e for pgsql-admin@arkaria.postgresql.org; Wed, 07 Apr 2021 11:23:09 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_256_GCM_SHA384:256) (Exim 4.92) (envelope-from ) id 1lU6H6-00035R-Sp for pgsql-admin@lists.postgresql.org; Wed, 07 Apr 2021 11:23:08 +0000 Received: from mail-qk1-x72f.google.com ([2607:f8b0:4864:20::72f]) by magus.postgresql.org with esmtps (TLS1.3:ECDHE_RSA_AES_128_GCM_SHA256:128) (Exim 4.92) (envelope-from ) id 1lU6H4-0000t0-RC for pgsql-admin@postgresql.org; Wed, 07 Apr 2021 11:23:08 +0000 Received: by mail-qk1-x72f.google.com with SMTP id y5so18173140qkl.9 for ; Wed, 07 Apr 2021 04:23:06 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=content-transfer-encoding:from:mime-version:subject:date:message-id :references:cc:in-reply-to:to; bh=tW8YLrnlT1TYl0jiHrDMWPn981iUOhExMRLC36UKscY=; b=jxcvrpXAWVZp4Arr//HKOYrW611we0RbxMmDYrNk5KpoaXvs967lyLDj4vWXv0IekJ pWQpeRsXAlghIAYXgWm+FB0Pn7uBjAWajF0e+MfY+GGGqmddR3QEVS+wIAl0hN6D87Wl CEKLrc453W34Zzn3Dd7Iw0L9lB4LzAfvkNwinyTQ+SzKhbeDf8a0DuSSnCOY3TqePlGC rG71n85VNAY9g9IRJtyTnYnbaGHkuyEOvzNmnHsNo3JWv4VtZreZ0h7P6A49q57GAcdB /bIYUHUaKkh3vyNYvkPp/pZFTRvkTKJGV8auXiZYfMwWVhi+O2tCYbzGRAfZOgkul3gq Ej8g== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:content-transfer-encoding:from:mime-version :subject:date:message-id:references:cc:in-reply-to:to; bh=tW8YLrnlT1TYl0jiHrDMWPn981iUOhExMRLC36UKscY=; b=GMtF4te/KKCrGo9z61boFulZ3B03Yeb0xvJnO4/cew6HfL8wzB3HLazA6ebVVJDL7g lFHJ0UNVDXG91JBLtClCf3qhBfhgrV1LtYZch/zLcQIlFoUWsrktsbEr5mMhXRsJMDB/ OPbR8NyIeveVibWRNh+MlgpPpuiJmJrNKSHUt03etIVl/srxPoR46nph7TzqeqWL2HIT 00uMyUay6zyhqTy1Wl92lQKwjrUJe+scBx7FytqxD5PTAE+zovL4BbXweWb8LuMuUCrB LSKOWUapQ1kUxVnUvkwbCGRxT5//5nSD8rKnGRfmW8WjA5z/pnwBj3cv/4S87yRslt4I Rz9Q== X-Gm-Message-State: AOAM531CcEVCSGhPCJJU9/WgT8+E/JxPQbOMECX3LbIdoR0Tdm80qwD+ 6pkqLYUIKDKCs7vSknDJD9w= X-Google-Smtp-Source: ABdhPJx8LKMBK2geDjLCUNkCU41Wq8Tn6+9KziRO4QHNavPJSGkzRflPFhIgwHnuEtt525HFWxI5/g== X-Received: by 2002:a37:9e56:: with SMTP id h83mr2677599qke.38.1617794585181; Wed, 07 Apr 2021 04:23:05 -0700 (PDT) Received: from [192.168.0.6] (75-109-90-86.nlsncmtc01.res.dyn.suddenlink.net. [75.109.90.86]) by smtp.gmail.com with ESMTPSA id r17sm15997414qtx.62.2021.04.07.04.23.04 (version=TLS1_3 cipher=TLS_AES_128_GCM_SHA256 bits=128/128); Wed, 07 Apr 2021 04:23:04 -0700 (PDT) Content-Type: multipart/alternative; boundary=Apple-Mail-26E9B022-10C5-4637-8C98-95613ED26C2D Content-Transfer-Encoding: 7bit From: John Scalia Mime-Version: 1.0 (1.0) Subject: Re: PG_CRON in AWS RDS PostgreSQL Date: Wed, 7 Apr 2021 07:23:02 -0400 Message-Id: References: Cc: pgsql-admin In-Reply-To: To: Prashant Kulkarni X-Mailer: iPad Mail (18D70) List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Archived-At: Precedence: bulk --Apple-Mail-26E9B022-10C5-4637-8C98-95613ED26C2D Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: quoted-printable I recently looked into this for one of my development teams. Pg_cron require= s that you=E2=80=99re running version 12.x or higher. Unfortunately, my team= is still running v.11.9 so we couldn=E2=80=99t use pg_cron. =E2=80=94 Jay Sent from my iPad > On Apr 7, 2021, at 7:17 AM, Prashant Kulkarni w= rote: >=20 > =EF=BB=BF > Hi Team, >=20 > Please anybody can share the details regarding PG_CRON in AWS RDS.=20 >=20 > 1.How to schedule jobs using PG_CRON in AWS RDS instances. > 2.Can we execute any SQL script on schedule basis using pg_cron in RDS?=20= >=20 > Thank you!! --Apple-Mail-26E9B022-10C5-4637-8C98-95613ED26C2D Content-Type: text/html; charset=utf-8 Content-Transfer-Encoding: quoted-printable I recently looked into this for one of my d= evelopment teams. Pg_cron requires that you=E2=80=99re running version 12.x o= r higher. Unfortunately, my team is still running v.11.9 so we couldn=E2=80=99= t use pg_cron.
=E2=80=94
Jay

Sent from= my iPad

On Apr 7, 2021,= at 7:17 AM, Prashant Kulkarni <ppk10.prashant@gmail.com> wrote:
=EF=BB=BF
Hi Team,

Please anybody can shar= e the details regarding PG_CRON in AWS RDS.

1.= How to schedule jobs using PG_CRON in AWS RDS instances.
2.Can we execute any SQL script on schedule basis using pg_cron in RD= S?

Thank you!!
= --Apple-Mail-26E9B022-10C5-4637-8C98-95613ED26C2D--