bisonjin commented on issue #8019: URL: https://github.com/apache/dolphinscheduler/issues/8019#issuecomment-1012816966
> > The document still needs more details. E.g., how to specify the condition of stored procedure failure. Because although there are sql execution errors in the procedure, the job result is always successful. Currently, I have no idea how to figure out if the jobs are really successful without any errors. > > @bisonjin I just add general addition information for each task type, do you have time to add this document? I do not have much experience about Stored Procedure job Sure, but I first need to know how dolphinscheduler decides if a task is successful or failed. One failure scenario that works is when Dolphin cannot find the stored procedure, and it will send me an email alert according to my alert configuration. However, Dolphin cannot recognize when there are sql execution errors in the store procedure. I can return an error code from the stored procedure to Dolphin, but how can I tell Dolphin to read this error code and decide that this job failed and send me an alert. -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected]
