Thread: Pg_cron
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
Did u configure pg_hba local connection as trust?
On Wed, 22 May 2024, 15:27 Sathish Reddy, <sathishreddy.postgresql@gmail.com> wrote:
HiI have pg_cron created extension on one database but I am trying to schedule job to another database from same database.Database ADatabase BI need to do vaccum datbase B from database A using pg_cron.Help us.ThanksSathish Reddy
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