how to modify sql job to remove extra information coming in text file

• huum

  Say Hey Kid

  Points: 693

  More actions

  July 10, 2013 at 2:26 pm

  #275974

  I am exporting the sql query result set to a text file and its writing without the issue,

  i want to eliminate lot of extra information it is writing For example

  Job 'myNIC_PROD_ActiveUsers_In_Last5Minutes' : Step 1, 'Active_Users' : Began Executing 2013-07-04 18:25:47

  NumberRows Time_stamp

  ----------- ------------------------------------------------------

  39 2013-07-04 18:25:47.630

  (1 rows(s) affected)

  So i only need to see Bold text in this post

• Erland Sommarskog

  SSC-Insane

  Points: 24038

  More actions

  July 11, 2013 at 2:51 am

  #1631497

  Run the job as a CmdExec job that runs sqlcmd that directs the output to the desired file. Include SET NOCOUNT ON to get rid of "1 rows affected".

  [font="Times New Roman"]Erland Sommarskog, SQL Server MVP, www.sommarskog.se[/font]