Why pgAgent Jobs Not Working || How To Fix pgAgent Jobs || pgAgent For pgAdmin || PostgreSQL pgAgent

[@Knowledge360Channel]

*Please help me get that beautiful KZbin Silver button. Do subscribe to the channel if my video was helpful.* ❤

[@GiangNguyen-dx5ck]

It works fine on the default postgre database but not other databases

[@Knowledge360Channel]

Yes, pgAgent works with Postgres database. I am finding an easy way to make this work for other databases as well.

[@Knowledge360Channel]

I have made the Video On this. Please do watch. Why pgAgent Not Working On Another Database Other Than Postgres - kzbin.info/www/bejne/d2PZfXZpftetma8

[@ELVINGONZALEZ-l3m]

hello. my problem is when i create a job i try to create a schedule and i get a error: Failing row contains (19,16,time,,t 2024-05-13 14:13?-3, null {t,t,t,t,t,t,t,t,t,t,t,t,t,t,t,t,t,t,t,t} l {t,t,t,t,t,t}....... new row for relation 'pga_schedule violate check constrain pga_schedule

[@Knowledge360Channel]

Can you share the complete schedule job creation script

[@thulasiv7262]

I can't see "pgagent job" in pgadmin4. How to resolve this issue?

[@Knowledge360Channel]

I believe pgAgent Jobs has not been added to your Postgres. Please watch this video to learn how to add pgAgent to Postgres. kzbin.info/www/bejne/eYeaq6WgmrFli9E

[@thulasiv7262]

Thanks for your reply. Problem solved😊

[@Knowledge360Channel]

@@thulasiv7262 Please subscribe to my channel 😊

[@sumorichis]

Thanks for this Video. Great channel. 🙂 Similarly... how can I create a pgAgent job wich is creating a backup of a database using pg_dump? Thanks

[@Knowledge360Channel]

Thanks for the appreciation. I have been trying to do it. Once I got the solution, shall make a video on it.