Is it possible to send the whole output of a query directly in the email instead of notifying the application team with the output attachment . I have a request in which the team wants the whole output to be printed in the email rather than in attached default file after the job completion .

So you mean to say there should be one out condition force job with the main job wherein I have to give ctmpsm -LISTSYSOUT %%MY_ORDERID | mailx -s . And I should disable the notification of the main job and enable the notification for the force job ?