July 10, 2014 at 6:21 am
Hi Experts,
I ticked the option to write the result to job history when i ran an update script inside a job. I did this because the update was so huge and i was worried about session getting closed after sometime if i ran it in a query.
Job completed successfully but i didnt get the number of rows updated ,anyone have any idea why it didnt give the result in job history??
July 11, 2014 at 12:05 am
Row count is not returned in job history unless explicitly specified
print @@rowcount
Cheers
July 11, 2014 at 3:31 am
You'll only see output for the things that return an output from your statements.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply