<div>
If that's something you need to know, I'd log it into a table then include a SELECT in the email to pull the relevant data for that email. &nbsp;You could set up a process to automatically delete obsolete data from the table.
</div>


If that's something you need to know, I'd log it into a table then include a SELECT in the email to pull the relevant data for that email.  You could set up a process to automatically delete obsolete data from the table.

<div>
<div class="content wysiwyg-content">
Hello experts. I have a sql script the runs a stored procedure. The stored procedure clears and updates some rows in some tables. So when I run the sql script in visual studio, it shows me the results of what rows were updated. Example:<br />
0 rows affected<br />
0 rows affected<br />
84 rows affected<br />
<br />
I want to run this job as a scheduled job and I think I have it setup correctly. Except here is my question. When the scheduled job kicks off all I get is an email that the job was successful but I do not see what rows were affected like I do in visual studio. Is it possible to see what rows were affected via a schedule job and if so how?
</div>
</div>


Hello experts. I have a sql script the runs a stored procedure. The stored procedure clears and updates some rows in some tables. So when I run the sql script in visual studio, it shows me the results of what rows were updated. Example:
0 rows affected
0 rows affected
84 rows affected

I want to run this job as a scheduled job and I think I have it setup correctly. Except here is my question. When the scheduled job kicks off all I get is an email that the job was successful but I do not see what rows were affected like I do in visual studio. Is it possible to see what rows were affected via a schedule job and if so how?

sql server agent jobs schedule question

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.

Microsoft SQL Server 2008

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.