Re: [Patch][pgAdmin4]: Fix pgagent issues

Hi Neel 

RESQL test cases are failing on my machine due to different timezone 

-     '2020-04-14 01:11:31-07'::timestamp with time zone, '2020-04-15 01:11:34-07'::timestamp with time zone,
?                 -  ^    ^ ^                                         -  ^    ^ ^
+     '2020-04-14 13:41:31+05:30'::timestamp with time zone, '2020-04-15 13:41:34+05:30'::timestamp with time zone,
?                  + ^    ^ ^^^^                                          + ^    ^ ^^^^

Please fix the above issue and resend the patch. 

On Mon, Apr 20, 2020 at 3:07 PM Neel Patel <neel.patel@enterprisedb.com> wrote:

Hi,

Please find the attached patch to stabilize the pgagent and fix below issues.

• Reverse engineering SQL and MSQL was incorrect when the user added a job schedule with exception Fixes #5356
• Job schedule exception time was not showing correctly in SQL tab.
• Identify the job step and schedule if disabled from browser tree, same as pgagent job - Fixes #4636
• Add RE-SQL/MSQL test cases for pgAgent Jobs - Fixes #4623
  

Do review it and let me know for comments.

Thanks,

Neel Patel

--

Thanks & Regards

Akshay Joshi

Sr. Software Architect

EnterpriseDB Software India Private Limited

Mobile: +91 976-788-8246