Print Thread
DBMS scheduler, job properties, Log and Run details, how do I see all log rows?
#62929 01/31/22 10:12 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
From the new features page: "Job view/edit performance improvement: Logs and Run details are now fetched on demand and limited to 100 most recent rows."

This is a great feature and a potential time saver in daily work, but I need to be able to see older logs, e.g. row number 200. How can I do this? Is there an option where I can set the number of rows to fetch?
I think we maybe need buttons like 'Fetch next 100' and 'Fetch all', like we have in the SQL grid.

Re: DBMS scheduler, job properties, Log and Run details, how do I see all log rows?
Claus Pedersen #62946 01/31/22 10:44 AM
Joined: Aug 1999
Posts: 22,214
Member
Offline
Member
Joined: Aug 1999
Posts: 22,214
This is currently not possible from within the job definition editor. Only 100 the most recent logs are displayed.


Marco Kalter
Allround Automations
Re: DBMS scheduler, job properties, Log and Run details, how do I see all log rows?
Claus Pedersen #62956 01/31/22 11:51 AM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Can it be an option then, how many rows are fetched? Otherwise the user will have to use the Oracle view to see relevant data, and that is a little more cumbersome than using the job properties tab pages

Re: DBMS scheduler, job properties, Log and Run details, how do I see all log rows?
Claus Pedersen #62979 02/01/22 01:22 AM
Joined: Feb 2013
Posts: 251
UTC+10
I
Member
Offline
Member
I
Joined: Feb 2013
Posts: 251
UTC+10
Hi,
I agree,
An option for number of rows or 'Fetch All' button would be very helpful. For now this is kind of regression in functionality.

Re: DBMS scheduler, job properties, Log and Run details, how do I see all log rows?
Claus Pedersen #62990 02/01/22 10:24 AM
Joined: Aug 1999
Posts: 22,214
Member
Offline
Member
Joined: Aug 1999
Posts: 22,214
We'll add an option for this.


Marco Kalter
Allround Automations
Re: DBMS scheduler, job properties, Log and Run details, how do I see all log rows?
Claus Pedersen #63004 02/01/22 03:49 PM
Joined: Sep 2009
Posts: 165
California
J
Member
Offline
Member
J
Joined: Sep 2009
Posts: 165
California
I agree. I do love that it is limited now. I had a job that ran every minute and if I accidently clicked the run details tab it would hang for a long time while fetching. But even with that an option to see all rows just like a sql window would be needed.

Re: DBMS scheduler, job properties, Log and Run details, how do I see all log rows?
Claus Pedersen #63147 02/07/22 04:08 PM
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Member
OP Offline
Member
Joined: Dec 2005
Posts: 2,004
Roima Denmark
Solved in beta 2


Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.059s Queries: 14 (0.013s) Memory: 2.5204 MB (Peak: 3.0380 MB) Data Comp: Off Server Time: 2024-05-10 08:16:34 UTC
Valid HTML 5 and Valid CSS