09/20/2022 06:17 AM
Our customer is using the 5.5 branch and CUSTOMQUERYJOB is marked as being depricated. It has been used a lot for many maintenance and troubleshooting tasks.
When can we expect this feature to not be available anymore? Is there a feature that can be used instead? Using the APIs for every small db update is not a very good option.
Solved! Go to Solution.
09/20/2022 09:39 AM
in v2020.0 its available but named as Deprecated so in future it might be
v2021 - You can't create new customquery job but you can use existing jobs
09/20/2022 10:07 AM
We are still supporting the CUSTOMQUERYJOB in the latest EIC v2022. Please refer to our product documentation. https://saviynt.freshdesk.com/support/solutions/articles/43000677348
09/20/2022 10:31 AM
09/20/2022 11:29 AM
Copy/Pasting here - You should be able to access it.
Custom Query Job v2 is the new and improved framework to create and manage Custom queries in EIC. v2 includes many updates and features, such as faster execution time, less susceptible to deadlocks etc.
With the introduction of Custom Query Job v2 we have also introduced certain restrictions in the Custom Query v1 to encourage the usage of v2 and avoid the known issues with v1. So when migrating the application from previous versions to EIC, keep in mind the following considerations and limitations for existing custom queries as described in below section. Remediation may need to be performed on existing queries as applicable to make them compatible with EIC.
Creation of new job triggers will not be supported for custom query v1 in EIC. Any new trigger need to use Custom Query v2.
Usage of stored procedures are not allowed in EIC. Hence calling stored procedures within the custom query is also not supported anymore. Any existing query performing this operation need to be remediated.
Usage of DB functions are not allowed in EIC. Hence calling DB function within the custom query is also not supported anymore. Any existing query performing this operation need to be remediated.
The following statements are not supported:
The following statements are supported:
09/20/2022 10:54 PM
Thanks Dave and Belwyn for this new information.
In what version this new v2 custom query functionality will be?
We don't have access to this Freshdesk link, can you change it's permissions?: https://saviynt.freshdesk.com/support/solutions/articles/43000677348
09/21/2022 08:26 AM
Just following-up that I have asked my contact that manages FreshDesk, and I will report back what they say. Thank you.
02/14/2023 03:16 AM
Did you got some information about this and when this version 1 and version 2 separation will be taken into use?