<div>
But I'm trying to trace a job that ran last night.
</div>


But I'm trying to trace a job that ran last night.

<div>
Sorry, There is no way unless you have any audit or dml trigger on the tale.
</div>


Sorry, There is no way unless you have any audit or dml trigger on the tale.

<div>
<div class="content wysiwyg-content">
I have scheduled a job that has a delete strategy based on a time-stamp column. It is working fine.<br />
<br />
But, I would like to know how many rows were affected/deleted in a single run. Is it possible to trace??<br />
<br />
I see the duration was 00:00:00 but it doesn't mean that no rows were affected...
</div>
</div>


I have scheduled a job that has a delete strategy based on a time-stamp column. It is working fine.

But, I would like to know how many rows were affected/deleted in a single run. Is it possible to trace??

I see the duration was 00:00:00 but it doesn't mean that no rows were affected...

Tracing sql job

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.