Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
| Dev |
|
| QA |
|
| Priority | Low |
| Complexity | Unknown |
| Component | DB - MS SQL Server |
| Version | 19.5 |
Case# 00598661
I'm using Aqua Data Studio 18.0.18 and at the moment I'm transferring Sql Server jobs between servers.
It would be great if job icon (in SQL Server Agent - Jobs) would be different for disabled jobs. In Microsoft SQL Server Management Studio the disabled jobs have small red X on their lower left corner. Something similar would be useful. Maybe like what is shown in attached picture.
|
|
3 KB
|
|
149 KB
|
|
91 KB
|
|
95 KB
|
|
115 KB
|
|
104 KB
|
919 B
Hi Juhi,
I started the SQL Server Agent on the 2016 SQL Server(SQL Server 172.24.1.199 2016). You should be able to create a test job and disable it. See screenshot.
The base class for the change is MSJobNode. Notice the constructor sets the icon. Your team will have to add some logic in the query in MSJobsNode class to determine whether the job is disabled or not. The query does return a column called "enabled". See MSJobNode->constructPopupMenu for the different types of icons.
Hope that helps...
Thanks, Tom
Implemented the issue and pushed the code for the same.
Unit test -
Implemented the issue and pushed the code for the same.
Unit test -
Hi Bhagyashree,
I attached createNode.txt. Have a look at that? Can we implement and test the change using that logic? This way we won't have to execute the extract query twice.
Please have a look!!
Thanks, Tom
Hi Bhagyashree,
I attached createNode.txt. Have a look at that? Can we implement and test the change using that logic? This way we won't have to execute the extract query twice.
Please have a look!!
Thanks, Tom
Hi Tom,
I have changed the logic as per your comment , and pushed the code.
Please have a look.
Thanks, Bhagyashree
Hi Tom,
I have changed the logic as per your comment , and pushed the code.
Please have a look.
Thanks, Bhagyashree
Hi Bhagyashree,
Code change looks good.
Thanks, Tom
Hi Bhagyashree,
Code change looks good.
Thanks, Tom
Issue #15482 |
| Verified |
| Fixed |
| Resolved |
Completion |
| No due date |
| Fixed Build ADS19.5.0-dev-14 |
| No time estimate |
Hi Juhi,
I started the SQL Server Agent on the 2016 SQL Server(SQL Server 172.24.1.199 2016). You should be able to create a test job and disable it. See screenshot.
The base class for the change is MSJobNode. Notice the constructor sets the icon. Your team will have to add some logic in the query in MSJobsNode class to determine whether the job is disabled or not. The query does return a column called "enabled". See MSJobNode->constructPopupMenu for the different types of icons.
Hope that helps...
Thanks, Tom