How To Schedule A Job Using pgAgent Jobs In PostgreSQL Database Using pgAdmin || PostgreSQL pgAgent

#knowledge360 #akramsohail #akramsohailproject
You Are Hearty Welcomed To My Channel Knowledge 360. Here I post technical videos, mainly related to computer science and programming. I am posting project videos with coding explanations. I make tutorial videos on Technical Topics. Stay Connected, Stay Tuned, Study Smart.
– Knowledge 360 (Akram Sohail)

Follow me on Social Media
————————————————–
Facebook – https://www.facebook.com/sonu.babu.5872682/
Instagram – https://www.instagram.com/akkubakku007/
WhatsApp – https://wa.me/+919090484904
LinkedIn – https://www.linkedin.com/in/akram-sohail-499489131/
Skype – https://join.skype.com/invite/snliyulHrEBb
Google+ – https://plus.google.com/u/0/116728183002228924227
Blog – https://knowledge360blog.blogspot.in/

Business/Mentorship/Projects – [email protected]
Source Codes –

Topics
———
Oracle
MySQL
PostgreSQL
SQL Server
PHP
C
C++
Java
JavaScript
HTML/CSS
jQuery
Ajax
Bootstrap
Angular
Linux
Ubuntu
Windows

Description
——————

How To Schedule A Job Using pgAgent Jobs In PostgreSQL Database Using pgAdmin PostgreSQL pgAgent

first, lets create a table.

Now, I will schedule a job and insert record into the table through
scheduler

I scheduled it to run it from 9:05 PM, currently I am at 09:00 PM

It is 09:03 PM now, and 2 minutes remaining…
Let’s check if there is any data or not.
There should be no record now.

Here we can see the records are inserted…

In the next video, I will show

How to perform some complex operations through a scheduled job
in PostgreSQL

Subscribe my channel….

create table emp(id numeric, name character(30),salary numeric);

select * from emp;