|
DBMS scheduler, job properties, Log and Run details, how do I see all log rows?
|
Joined: Dec 2005
Posts: 2,004 Roima Denmark
Member
|
OP
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?
|
Joined: Aug 1999
Posts: 22,214
Member
|
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?
|
Joined: Dec 2005
Posts: 2,004 Roima Denmark
Member
|
OP
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?
|
Joined: Feb 2013
Posts: 251 UTC+10
Member
|
Member
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?
|
Joined: Aug 1999
Posts: 22,214
Member
|
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?
|
Joined: Sep 2009
Posts: 165 California
Member
|
Member
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?
|
Joined: Dec 2005
Posts: 2,004 Roima Denmark
Member
|
OP
Member
Joined: Dec 2005
Posts: 2,004 Roima Denmark |
|
|
|
|
|
|