I can reproduce the problem with the 2 hours sleep procedure. I scheduled it to run every 4 hours and it's stuck running since 4 PM yesterday (The firts time it ran).
I also tried to run it with a 2 minute sleep and it completed successfully.
The Oracle Server version is 18.104.22.168.
The Oracle client version was 22.214.171.124 on our VisualCron TEST server and 126.96.36.199 on our PROD server. To make sure the problem on the PROD server is not related to the Oracle client, I uninstalled it and installed version 188.8.131.52 and we still have the same problem.
I'm not sure what you mean here: "Can you also tell us if you can refresh stored procedures correctly in the interface?"
Here is the connection String:
Data Source=BICJTEST;User Id=HIDDEN;Password=**********;Unicode=true;
This is what we have in tnsnames.ora on the VisualCron server:
Edited by user
| Reason: Not specified