Task Step Completes but doesn't go to next step
Posted: Sat Mar 25, 2023 4:31 am
I am running a MySQL Stored procedure in a task step.
So I open the database,
DB Exec SQL which does a call to the stored procedure,
than dbclose
The stored procedure for sure completes, as the last statement updates a value in a table and that's happening, but the Task still shows as running.
Is there something I can do to try to figure out what's happening?
If I could restart the application at some time during the night, that might also work. Not sure if there is a way to do that or not. Actually would I restart the application or the service? Not quite sure.
Thanks
Alan
So I open the database,
DB Exec SQL which does a call to the stored procedure,
than dbclose
The stored procedure for sure completes, as the last statement updates a value in a table and that's happening, but the Task still shows as running.
Is there something I can do to try to figure out what's happening?
If I could restart the application at some time during the night, that might also work. Not sure if there is a way to do that or not. Actually would I restart the application or the service? Not quite sure.
Thanks
Alan