On SQL Server, you can use the following query to find out whether the procedure is waiting:
SELECT sqltext.text, sp.* FROM sys.sysprocesses sp OUTER APPLY sys.dm_exec_sql_text(sp.sql_handle) sqltext WHERE sp.blocked <> 0 AND sqltext.text LIKE '%vid_JobGetForCache_3%'
Any further resolution depends on the result.
The information in the script(s) provided is known to work successfully; however, they have not been officially tested by One Identity Quality Control. If any of these instructions are changed and/or incorrectly used, intentionally or unintentionally, this solution becomes unsupported by One Identity Support and Development. One Identity Support and Development recommend always making a backup of the current database prior to execution of any script(s) that may modify it.
© 2024 One Identity LLC. ALL RIGHTS RESERVED. Terms of Use Privacy Cookie Preference Center