Hello,
I have a workflow that runs well but now has 3 extra steps at the end of it to consider. All 3 steps involve invoking a Stored Procedure that triggers an Oracle concurrent job and needs to do some check to make sure the previous job finished before moving onto the 2nd and 3rd jobs, etc. So rudimentarily something like this:
Do a bunch of stuff and then at the end pass some user variables and execute a stored proc post sql (this is complete and working) -> do some check to make sure the concurrent job the stored procedure ran has finished, then kickoff the next stored procedure w/user driven variables -> check to make sure that concurrent job completed -> run the final one
So basically my question is, is there a tool where after I run the first job, I can tell Alteryx to run a query to look to see if the job completed and if it did to continue on, my issue is each job may take a few hours so while it's not the end of the world if the workflow takes 8 hrs or whatever to finish since that's probably what would happen IRL if someone manually looked in the table and then kicked off another concurrent job, etc, I'm wondering if there's a more efficient way in Alteryx to handle checking something on the backend and only after it satisfies that criteria, move onto the next container in the workflow.
Thanks
