Execute Permission missing for cron.alter_job for azure_pg_admin

Question

Hi Team,

For Scheduling jobs in different databases, we must need to use cron.alter_job or cron.schedule_in_database functions available inside cron schema. But in my flexible server, both functions are having only execute permissions for azuresu user. Because of that i could not schedule jobs. In other subscriptions I could see that execute permissions for both azuresu and azure_pg_admin. Kindly help in resolving the same. My flexible server version:13.7

Thanks and regards,
Manimahesh S

Answer 1

Hi, @Mani Mahesh Sivakumar Welcome to the Microsoft Q&A Platform, and thanks for your query.
If you move pg_cron to another DB you can do everything, only if it stays in Postgres you aren't able to do much.

Try to change this to any database owned by a normal user.

Please let me know if you find any issues.

Regards
Geetha