Trigger configuration in Orchestrator Data Base

Help
1

Hello everyone,

I would like to receive an email whenever a new package or new version of a package is uploaded to my Orchestrator, I tried configuring the following trigger in the [dbo].[PackageDefinitions] table:

CREATE TRIGGER packageAlerts
ON [dbo].[PackageDefinitions]
AFTER INSERT, UPDATE, DELETE
AS
EXEC msdb.dbo.sp_send_dbmail
@profile_name = ‘’,
@recipients = ‘xxxxx@yyy.com’ ,
@body = ‘Packages in the Orchestrator have been Inserted/Updated/Deleted’,
@subject = ‘Alert: Changes in packages from Orchestrator’
GO

The problem is that I did not only not receive any email, I was also unable to upload or publish any new package to my Orchestrator (I would receive the message “An error has Ocurred”). Can anybody see something wrong with this? Is there a workaround fir this that does not imply purchasing another license of any kind.

Thank you for your help.

AM.

2

Orchestrator does not write data to the PackageDefinitions table when changing process versions.
Maybe managing data within the application.
It might be good to use process.updated of Webhooks as a trigger.