From: abbas alizadeh <ramkly@yahoo.com>
To: Sathish Reddy <sathishreddy.postgresql@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Pg_cron
Date: Wed, 22 May 2024 15:07:08 +0400
Message-ID: <E8103859-2AEA-463D-AE48-3BC16285E06A@yahoo.com> (raw)
In-Reply-To: <CA+M9Y+BMojbqZDtdYiQ=Hm0tYrn7CkfC-3dD2HEho0-5TZBDfg@mail.gmail.com>
References: <CA+M9Y+BMojbqZDtdYiQ=Hm0tYrn7CkfC-3dD2HEho0-5TZBDfg@mail.gmail.com>
Hi.
With function cron.schedule_in_database you can schedule the job for different databases
Regards
Abbas
> On 22 May 2024, at 1:57 PM, Sathish Reddy <sathishreddy.postgresql@gmail.com> wrote:
>
>
> Hi
> I have pg_cron created extension on one database but I am trying to schedule job to another database from same database.
> Database A
> Database B
>
> I need to do vaccum datbase B from database A using pg_cron.
>
>
> Help us.
>
>
> Thanks
> Sathish Reddy
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: ramkly@yahoo.com, sathishreddy.postgresql@gmail.com, pgsql-admin@lists.postgresql.org
Subject: Re: Pg_cron
In-Reply-To: <E8103859-2AEA-463D-AE48-3BC16285E06A@yahoo.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox