Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hYASq-00076x-3d for pgadmin-hackers@arkaria.postgresql.org; Tue, 04 Jun 2019 14:31:00 +0000 Received: from localhost ([127.0.0.1] helo=malur.postgresql.org) by malur.postgresql.org with esmtp (Exim 4.89) (envelope-from ) id 1hYASp-0002a0-2L for pgadmin-hackers@arkaria.postgresql.org; Tue, 04 Jun 2019 14:30:59 +0000 Received: from makus.postgresql.org ([2001:4800:3e1:1::229]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hY4SP-0005Pl-6N for pgadmin-hackers@lists.postgresql.org; Tue, 04 Jun 2019 08:06:09 +0000 Received: from mail-ed1-x532.google.com ([2a00:1450:4864:20::532]) by makus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.89) (envelope-from ) id 1hY4SK-0001iD-6c for pgadmin-hackers@postgresql.org; Tue, 04 Jun 2019 08:06:08 +0000 Received: by mail-ed1-x532.google.com with SMTP id a8so30712002edx.3 for ; Tue, 04 Jun 2019 01:06:03 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20161025; h=mime-version:references:in-reply-to:from:date:message-id:subject:to :cc; bh=WiErX2683v2fnnIkGcewSEJJEwvtG8877YNqaGVO5BE=; b=SyUbJtJ5WwxpKf8BocH4ngqYiSw4knrNtr8USejv3k5Sb4+zU1EtkfcSoyEcSuvUEx ei/UED6m+3pV7qV3URPBF11umoDCzTwgpeI4BKmnqV0O1MFD7GoAko6dkdjO2rqpNvvG fNKNNRyuLDDBhLoARyS9Ubg6EDlE41LouIGnHfIyl+JQ/xAz9HJrB6HNmzng8qrFjU+H jrFJgJ4+egQZRfljnVGekclPpU0ucPSF5NayB1/VBgBEZt52lUwUigEd2KE1I5c6UNRz cxgKjxYmw3Y39wEQQuJeoYV4LEx9neBPrNgxnvWS4udotjtGc4RPPCcqzIM51P6sD92K kJoA== X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20161025; h=x-gm-message-state:mime-version:references:in-reply-to:from:date :message-id:subject:to:cc; bh=WiErX2683v2fnnIkGcewSEJJEwvtG8877YNqaGVO5BE=; b=YplBCPJ1Rm9tcRu2pBO+Ma9NyuLDxMnQo6aBR7IxW+MrO7E3bG/WodMHFloeDJFF4N NaGtop3PPMj4tUmOax7gFs7pUr5IJ0guhzV4I51qTptzRZbtdwBbEvOIw5HeKX7azVXz Mi6DESmSu2EMWPPEojB4+/jpMAoaj6Bk3xIIfZxSJYF8J3hgdxXVVW8xSJBk/qgDUlYA LPx20o52xAVjJXyOeYMHUwMt/WQ1PWLJq/CMfr9sELPa3hjy2hVICV6n5ofx2/6XsjeC mISGm61ZmN5jbJm4y/AcmCzMaxnKCxcK4mudhZ125vNHpw8wfXKP34T6C85/vIIQQJak J5Ng== X-Gm-Message-State: APjAAAUv33ZYgwphj1u+YGtQ0yXw7100Haw564kksbNXnzxYUC29gCFA ooN9o5fBNXnwRPugqiFH7U6VwppGwgONTHQd4n8= X-Google-Smtp-Source: APXvYqy4DZUxROnH7WOKrtuF3/oa+YVpV4zgDMEtaMsJTcb6YQezOocvpeJsDMa2PESWc4iWW+i2WapRUMAYyzp+au8= X-Received: by 2002:aa7:ca01:: with SMTP id y1mr6684185eds.124.1559635562467; Tue, 04 Jun 2019 01:06:02 -0700 (PDT) MIME-Version: 1.0 References: In-Reply-To: From: John G198 Date: Tue, 4 Jun 2019 03:05:50 -0500 Message-ID: Subject: Re: Help on pgAgent To: Khushboo Vashi Cc: pgadmin-hackers Content-Type: multipart/alternative; boundary="000000000000ae1506058a7af3e3" List-Id: List-Help: List-Subscribe: List-Post: List-Owner: List-Archive: Precedence: bulk --000000000000ae1506058a7af3e3 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Yes, I did. But it doesn't run neither, it does update the next run date but doesn't actually do anything even the field last run still shows nothing. I checked the SQL as I'm trying to update a table column and the SQL is correct so I don't what is failing El lun., 3 de jun. de 2019 11:59 p. m., Khushboo Vashi < khushboo.vashi@enterprisedb.com> escribi=C3=B3: > > > On Tue, Jun 4, 2019 at 1:46 AM John G198 > wrote: > >> Hi im trying to use pgAgent on pgAdmin4 using Windows 10 and i cant see >> why but it doesnt work, it doesnt run the jobs created and i just want t= o >> know if it has something to do with my postgreSQL version 11.2 maybe >> pgAgent isnt compatible with this version. >> So could you let me know whats going on? and what alternative do i have?= , >> i really need to use Scheduled jobs for this web page db project i have >> > > Have you tried to run manually via *Run now* option in the context menu > of the pgAgent job? > --000000000000ae1506058a7af3e3 Content-Type: text/html; charset="UTF-8" Content-Transfer-Encoding: quoted-printable
Yes, I did. But it doesn't run neither, it does updat= e the next run date but doesn't actually do anything even the field las= t run still shows nothing. I checked the SQL as I'm trying to update a = table column and the SQL is correct so I don't what is failing=C2=A0
El = lun., 3 de jun. de 2019 11:59 p. m., Khushboo Vashi <khushboo.vashi@enterprisedb.com> esc= ribi=C3=B3:


On Tue, Jun 4, 2019 at 1:46 AM John G198 <jon= athandelatorre98@gmail.com> wrote:
Hi im trying to use pgAgent on p= gAdmin4 using Windows 10 and i cant see why but it doesnt work, it doesnt r= un the jobs created and i just want to know if it has something to do with = my postgreSQL version 11.2 maybe pgAgent isnt compatible with this version.=
So could you let me know whats going=C2=A0on? and what alternative do = i have?, i really need to use Scheduled jobs for this web page db project i= have

Have you tried to run man= ually via Run now option in the context menu of the pgAgent job?
=
--000000000000ae1506058a7af3e3--