it is a bit easier granted the PostgreSQL account used is a super user or has sufficient rights to the dbs.Ĭompared to Windows Scheduled Tasks - PgAgent has the following advantages:
#SQL TABS POSTGRESQL SUPER USER UPDATE#
![sql tabs postgresql super user sql tabs postgresql super user](https://www.mssqltips.com/tipImages2/2619_img6.jpg)
![sql tabs postgresql super user sql tabs postgresql super user](https://www.dbrnd.com/wp-content/uploads/2015/05/CreateFirstSQLJob-201x300.png)
PgAgent can run both PostgreSQL stored functions and sql statements as well as OS shell commands and batch tasks.
![sql tabs postgresql super user sql tabs postgresql super user](https://miro.medium.com/max/1280/1*D2BeTeC-xnuqIr2ApHTKew.png)
The PgAdmin III Job Agent interface to PgAgent should look very welcoming, but the schedule tab may look a little unfamiliar. Unix/linux cronjobs and crontab structure, PgAgent's scheduling structure should look very familiar.įor those familiar with using Microsoft SQL Server Scheduling Agent or Windows Scheduling Tasks, but not used to crontab structure, PgAdmin III is the database administration tool that comes packaged with PostgreSQL. PgAgent is a basic scheduling agent that comes packaged with PgAdmin III (since pre-8.0 or so) and that can be managed by PgAdmin III.