where can i read message from raiserror with nowait from a scheduled job

Question

where can i read output message from raiserror with nowait from a scheduled job. i know the msg outputs in the message when manually run the stored procedure has raiserror with nowait. but if it runs as a scheduled job where can i see it? i can not find it from the errorlog.

Answer 1

The SQL Agent log only contains the first 1000 chars of output. To get more output you must set the step to log to file.

See:
https://www.mssqltips.com/sqlservertip/1411/verbose-sql-server-agent-logging/