question

JiongAN-1498 avatar image
0 Votes"
JiongAN-1498 asked TomPhillips-1744 answered

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

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.

sql-server-generalsql-server-transact-sqlazure-sql-database
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

TomPhillips-1744 avatar image
0 Votes"
TomPhillips-1744 answered

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/

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.