Sample Header Ad - 728x90

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