The creation of job steps in SQL Server through DDL statements allows for creating steps with a none case sensitive subsystem type. Our code had the subsystem type key as case sensitive. We need to to modify the keys so that the map does not care about case sensitivity when comparing the data retrieved from the database to the type key string.
![]() |
509 KB
Changes made so the hashmap keyname is all CAPS.
Changes made so that retrieving information from the hashmap will not treat the key as case sensitive.
Attaching MaintenanceSolutions.sql file that contains scripts that create the jobs with steps having @subsystem in all caps. This was how the issue was originally encountered.
Issue #14420 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build v17.0.4-5 |
No time estimate |
Changes made so the hashmap keyname is all CAPS.
Changes made so that retrieving information from the hashmap will not treat the key as case sensitive.
Attaching MaintenanceSolutions.sql file that contains scripts that create the jobs with steps having @subsystem in all caps. This was how the issue was originally encountered.