Script execution output in job history

  • 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??

  • Row count is not returned in job history unless explicitly specified

    print @@rowcount

    Cheers

  • 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