SQL Anywhere 17 Scheduled Event Client Console Log Location

[former_member594221]

What is the location of the CLIENT console log for Scheduled Events?

message string('BEGIN MY PROCEDURE: ',getdate()) type status to client

[VolkerBarth · Accepted solution]

TO CLIENT is declared as "Send messages to the client application".

As events run within the database server, there is no "client application", so I would assume the MESSAGE output gets lost, and I would not know how the server should react upon a "TYPE ACTION/WARNING" message sent from the event...

AFAIK it's absolutely common to use MESSAGE TO LOG within events.

[former_member594221 · Accepted solution]

"assume the MESSAGE output gets lost"
I assume nothing, that's why I've asked.

[VolkerBarth · Accepted solution]

OK, I cannot answer your actual question. That being said, I just would strongly suggest to use MESSAGE TO CONSOLE or MESSAGE TO LOG (or TO SYSTEM LOG / EVENT LOG) within events because TO CLIENT is just not appropriate here.

If you want an "interactive output", there is the MESSAGE FOR CONNECTION variant which can be used to send messages to another database connection – if that is a client application and uses a WAITFOR ... AFTER MESSAGE BREAK loop, you could output the message there. Some questions on that can be found in the separate SQL Anywhere Forum.