Hello,

I was trying to implement a new logic to my Query Supervisor Program. Currently for all types of alerts I send a SQL7064 from exit program. But, now I want to link Query Supervisor with ABS alerting systems. As our ABS alerting systems are connected to generating Service Now Tickets. What I want to do is send a SQL7064 for all types of alerts except alerts for HOLD JOB and END JOB. For hold and end job I want to send a different Message_Id into the message queue. Is this possible ? Because I have been getting some error when I try to Send a SQO7065 for hold and end job. If it is not possible then how can I accomplish my task.

------------------------------
Santosh Yadav
------------------------------

#SQL

What type of error are you seeing?  I don't believe there's any restrictions on which messages that the Query Supervisor can send.

Hello Kent,

Thanks for replying. I got it fixed. It seems Query Supervisor can only send a SQL7064 as long as you use QSYS/QSQLMSG which is the default *MSG file from IBM. But, if you create and use your own message file, then you can send any Message id which you define in your personal file. The send_message command takes library as one of the inputs. 

I my case, I got my issue resolved by a different method. I still used SQL7064, but I changed my message_text that I was sending to the QSYSOPR queue. ABS had the feature to filter the text message and act accordingly and hence my issue got resolved. But, if ABS did not have that feature, then creating our own MSG file is the way to go I guess.