What kind of alert?  You can use the TABLERESULTS option and query the ensuing table, you can read the errorlog, or you can attempt to capture the message output of the DBCC command.  Only you know what your exact requirements are, and only you know what infrastructure you have in place to satisfy those requirements.  I would recommend that you read the Understanding DBCC Error Messages and Error Reporting sections of this page.

John