Claus Pedersen
Member³
When I right-click on a job in the object browser and select View/Edit, the DBMS Scheduler tool is opened with the current job in focus. This is OK.
I have some enhancement requests to the tool:
1) When I press right-click and select 'Refresh' on e.g. a job under 'Running jobs', the entire browser tree is collapsed, and I have to browse and open the database user and then find the job again. When selecting 'Refresh', the focus should still be on the current job.
2) When there are many logs/run details for a job, the screen can take a long time to refresh. Is it possible to have the same feature from the SQL window, where, as default, only the rows that will fit the current window are queried, and a green arrow (Fetch next page/Fetch last page) is available to query more or all rows?
3) When shifting focus from one running job to another, the job properties should automatically be refreshed, so e.g. Elapsed time and CPU Used are always refreshed when focus shifts from one job to another.
4) When e.g. is selected in the object browser, this should be reflected in the DBMS scheduler browser tree as well, so the current user is not always a part of the browser tree, but levels Running Jobs, Jobs, Schedules etc. are opened directly with the current users jobs visible without having to click to open the current user. Alternatively, there should be a user dropdown as a part of the DBMS scheduler in the same manner as in the object browser, where current user or a specific user can be selected.
I have some enhancement requests to the tool:
1) When I press right-click and select 'Refresh' on e.g. a job under 'Running jobs', the entire browser tree is collapsed, and I have to browse and open the database user and then find the job again. When selecting 'Refresh', the focus should still be on the current job.
2) When there are many logs/run details for a job, the screen can take a long time to refresh. Is it possible to have the same feature from the SQL window, where, as default, only the rows that will fit the current window are queried, and a green arrow (Fetch next page/Fetch last page) is available to query more or all rows?
3) When shifting focus from one running job to another, the job properties should automatically be refreshed, so e.g. Elapsed time and CPU Used are always refreshed when focus shifts from one job to another.
4) When e.g. is selected in the object browser, this should be reflected in the DBMS scheduler browser tree as well, so the current user is not always a part of the browser tree, but levels Running Jobs, Jobs, Schedules etc. are opened directly with the current users jobs visible without having to click to open the current user. Alternatively, there should be a user dropdown as a part of the DBMS scheduler in the same manner as in the object browser, where current user or a specific user can be selected.
