As we know that if a Workflow is scheduled by someone's user id and if the operator's account get disabled, the workflow will be failed and below type of error message will show.
Now its perfectly fine that if we reschedule that with some other's id which is active, the workflow will again work.
Now the requirement is to get the UserNames who has scheduled a workflow, so that if we can get this before, there will not be a single execution failure, we can schedule the workflow with someone else's id before make that Operator disabled.
Obviously if Adobe can understand that the Operator who scheduled the workflow is no more active now, hence shows error, there must be some table-attribute to get this "Scheduled By" login. Thanks for your help.
So you want to catch workflows that were scheduled by operators that are now disabled? There is a workflow logs table that might be useful for this purpose - xtk:workflowLog, which has a connection to currentOperator.
Also, you could take a slightly different approach around user governance -- if you use SSO and an enterprise ID you can deactivate the user from your Active Directory without needing to remove them from Campaign, so the workflows will continue. You'd likely want to periodically go through and clean it all up, however you would at least not be caught by surprise about workflows failling.