| From: | abbas alizadeh <ramkly(at)yahoo(dot)com> |
|---|---|
| To: | Sathish Reddy <sathishreddy(dot)postgresql(at)gmail(dot)com> |
| Cc: | pgsql-admin(at)lists(dot)postgresql(dot)org |
| Subject: | Re: Pg_cron |
| Date: | 2024-05-22 11:07:08 |
| Message-ID: | E8103859-2AEA-463D-AE48-3BC16285E06A@yahoo.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
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(dot)postgresql(at)gmail(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Luke Campbell | 2024-05-22 11:46:53 | displaying line breaks / increasing row height in pgadmin |
| Previous Message | Rajesh Kumar | 2024-05-22 10:06:59 | Re: Pg_cron |