if i execute the select statement by a automate job  then the result should be pipe-delimited text with header row.
for example the job executes a select statement   [select name,address from table]  then the result  should be pipe-delimited text with header row in a output file(text file).