Include stored procedure text output in the maintenance plan log
2
votes
0
answers
613
views
I have a maintenance plan subtask in SQL Server 2012 Enterprise that executes a stored procedure (or a SQL Server agent job).
In the log file for this maintenance plan, there are a few lines for this task, such as the start- and end- date, and the SQL statement used to execute the stored procedure.
Can I somehow generate text output in the stored procedure and have it included in the log?
It does not absolutely have to be part of the log file, but I would greatly prefer it that way. I would like to avoid another table which has to be separately cleaned up, backed up, documented, etc.
Asked by HugoRune
(371 rep)
Mar 6, 2017, 12:18 PM
Last activity: Oct 28, 2022, 12:57 PM
Last activity: Oct 28, 2022, 12:57 PM