SQL Server Agent - Do not show job step details and column headers in output file I have a SQL Server Agent job which runs a select statement on a schedule and appends results to a CSV file

(Right click the job --> properties --> advanced and then adding a file path to the output file location)

This is great except the output it generates displays 

Job 'MyJobName' : Step1, 'Step Name' : Began executing YYYY-MM-DD HH-MM-SS


as well as the column headers throughout the file (it adds this with each append)

Is there a way to not output the Job name / step details and column headers?
You can do this with SQLCMD

Query

remember to add nocount so it does not add the rows affected to the file

sqlcmd -Q"set nocount on; select * from sys.databases;"  -S localhost -D master -o  "c:\temp\test3.csv"


Your job step needs to be SQLCMD however


The file



Part of the output