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?