Hi Craig,
The current the DMC Job status is designed to indicate if the Job has successfully kicked off. And the return value of the job will not be checked.
I would suggest you to open a requirement for supporting Scripts (and support check in scripts return value) in Jobs against the Aha IBM under Db2 Data Management Console:
https://ibm-data-and-ai.ideas.aha.io/ This will allow other community users to vote on the requirement.
p.s. The User Defined Alert function under Monitor Profile does support Scripts. It will also check the script's return value (0, -1 or -2) and decide if it falls under Information / Warning / Critical Alerts with notification available. It is not recommended to use the User Defined Alerts to execute general scripts, as alerts will generally be tracked under the Notification center. And alerts generally are created for monitoring issues. But, if your script justify an alert when the execution failed. You can use it as a temporary workaround.
------------------------------
Jason Sizto
------------------------------
Original Message:
Sent: Thu April 29, 2021 11:54 AM
From: Craig Beaver
Subject: DMC 3.1.4 Job types
Hi Jason,
Thank you for the reply. I did use this method but I couldn't find a way to get the return back to the CLP. When the command fails the CLP script still completes successfully.
------------------------------
Craig Beaver
Original Message:
Sent: Wed April 28, 2021 08:18 PM
From: Jason Sizto
Subject: DMC 3.1.4 Job types
Hi Craig,
db2 commands can be run with CLP by adding "!" prefix. But, running as shell script "as is" is not supported in DMC today.
------------------------------
Jason Sizto
Original Message:
Sent: Thu April 22, 2021 04:07 PM
From: Craig Beaver
Subject: DMC 3.1.4 Job types
When creating a job with a job type of "CLP/shell script" how do I get it to run a shell script? Seems like it runs everything as a CLP script.
------------------------------
Craig Beaver
------------------------------
#Db2