Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable
From: abbas alizadeh <ramkly@yahoo.com>
Mime-Version: 1.0 (1.0)
Subject: Re: Pg_cron
Date: Wed, 22 May 2024 15:07:08 +0400
Message-Id: <E8103859-2AEA-463D-AE48-3BC16285E06A@yahoo.com>
References: 
 <CA+M9Y+BMojbqZDtdYiQ=Hm0tYrn7CkfC-3dD2HEho0-5TZBDfg@mail.gmail.com>
Cc: pgsql-admin@lists.postgresql.org
In-Reply-To: 
 <CA+M9Y+BMojbqZDtdYiQ=Hm0tYrn7CkfC-3dD2HEho0-5TZBDfg@mail.gmail.com>
To: Sathish Reddy <sathishreddy.postgresql@gmail.com>
Content-Length: 523
Archived-At: 
 <https://www.postgresql.org/message-id/E8103859-2AEA-463D-AE48-3BC16285E06A%40yahoo.com>
Precedence: bulk

Hi.
With function cron.schedule_in_database you can schedule the job for differe=
nt databases=20

Regards
Abbas

> On 22 May 2024, at 1:57=E2=80=AFPM, Sathish Reddy <sathishreddy.postgresql=
@gmail.com> wrote:
>=20
> =EF=BB=BF
> Hi=20
>   I have pg_cron created extension on one database but I am trying to sche=
dule job to another database from same database.
> Database A=20
> Database B
>=20
> I need to do vaccum datbase B from database A using pg_cron.
>=20
>=20
> Help us.
>=20
>=20
> Thanks=20
> Sathish Reddy=20