Within SQL Server, it is nice to know when objects are getting created, modified and or dropped. To configure DPA to alert you about these events, here are the steps:
Step 1 - Either edit an existing extended event session like system_heath or create a new session and have it watch for events named object_created, object_altered, object_deleted. On some versions, these are already part of the system_health extended event session, so check there first.
Step 2 - Configure a DPA alert to read this data (Alerts > Manage Alerts > Custom - Custom SQL Alert - Multiple Numeric Alert).
SQL Statement is shown in the attached script.