Can I create an announcement automatically when a ticket is created?

e.g.

Is it possible? Can i create a trigger to do that?

Thanks

SDP 9.1
MSSQL