Do we have an option to execute DB Command Job with out fail if it has multiple commands? If yes, how it works.
I have DB command job having multiple commands then my job execution will continue without fail even first command fails
DBCommand which is present in a job flow has a provision to include SQL statements separated by a semicolon. As part of the execution, these SQL statements get submitted one after the other.
In DBCommand we have an option to run the SQL statements even in case of failure when we check the option continue execution on failure. It will run the SQL’s even in case of failures.