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

Поделиться
HTML-код
  • Опубликовано: 18 ноя 2024

Комментарии • 27

  • @Knowledge360Channel
    @Knowledge360Channel  2 года назад +3

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

  • @s734music
    @s734music 2 года назад +1

    I like how you approach and explain things, thank you!

  • @ahmetmunirboluk4594
    @ahmetmunirboluk4594 Год назад +1

    Thanks for tutorial. You should create new DB firstly. Secondly Schedule a job. Because different errors may occur.(Couldn't get a connection to the database!)

    • @Knowledge360Channel
      @Knowledge360Channel  Год назад

      Thanks for the suggestions, will keep in mind 😊

    • @Knowledge360Channel
      @Knowledge360Channel  6 месяцев назад

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

  • @sharadgupta540
    @sharadgupta540 2 года назад +1

    Cool video

  • @technicalpagla6207
    @technicalpagla6207 2 года назад +1

    Nice one

  • @akramsohail6693
    @akramsohail6693 2 года назад +1

    great

  • @thulasiv7262
    @thulasiv7262 5 месяцев назад +1

    I followed the same steps mentioned in the video, but the scheduling is not working for me. No values are being inserted into my table. Could you please help?

  • @salinashaikh2661
    @salinashaikh2661 2 года назад +1

    Superb

  • @sakhsirawat4444
    @sakhsirawat4444 2 года назад +1

    Wow

  • @mosahebuddin1877
    @mosahebuddin1877 2 года назад +1

    Super

  • @ajirogheneaugustina3591
    @ajirogheneaugustina3591 2 года назад +1

    Please help, I tried restoring dvdrental on my postgreSQL I got an error message which states:
    Pg-store error could not execute query: Error constraint 'store_manager_staff_id_fkey' for relation store already exist.
    Command: WAS ALTER TABLE ONLY STORE
    Pg restore creating ACL public
    Pg_restore: warning errors ignores on store 128.
    I'm new to this and I can't find my way around it.
    This is what have been seeing, since yesterday, kindly help.

    • @Knowledge360Channel
      @Knowledge360Channel  2 года назад +2

      To restore the database, there must not the same thing present. It seems you have restored the database partially. Now, clean the database, and try restoring from the beginning.

    • @ajirogheneaugustina3591
      @ajirogheneaugustina3591 2 года назад +1

      Thanks, funny enough it has loaded but it never sent a success reply from beginning. I had to check table and views and I saw it there.

    • @Knowledge360Channel
      @Knowledge360Channel  2 года назад +2

      Okay, glad to hear that you got the solution. Please subscribe my channel to get the updates.

  • @balkissabarry1110
    @balkissabarry1110 2 года назад

    Great, please help me I tried to schedule an insertion but it doesn't word.

    • @Knowledge360Channel
      @Knowledge360Channel  2 года назад

      You're welcome 😊

    • @ninokum7984
      @ninokum7984 Год назад

      Lograste solucionar porque igual no me inserta los datos, segui el video pero no me sale

    • @danielgoful
      @danielgoful Год назад

      ​@@ninokum7984 i have same error :c

    • @mmbigil
      @mmbigil 6 месяцев назад

      @@ninokum7984 it didn't worked for me also

  • @mastimasti3898
    @mastimasti3898 2 года назад +1

    How to take backup with 100 rows from each table?

    • @Knowledge360Channel
      @Knowledge360Channel  2 года назад +1

      You can use fetch first 100 rows or rownum

    • @mastimasti3898
      @mastimasti3898 2 года назад +1

      @@Knowledge360Channel Table is having 1000 records but I want take backup only 200 records using pg_dump. Is it possible? Tell me how ?

    • @Knowledge360Channel
      @Knowledge360Channel  2 года назад +1

      No, it's not possible as per my knowledge