SQL Server Agent - Do not show job step details and column headers in output file
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