In the workflow following the SQL job add a script job with the following code. The variables I have set on the object allow me to select which host I want to pipe it to, which is useful if you have the SQL on your server and the target csv on another. You can probably add this to the post process tab of your SQL job too.
:SET &REPORT_TYPE# ='REP'
!Get the previous run in the workflow
:SET &RUNNR# = SYS_ACT_PREV_NR()
:SET &HND# = PREP_PROCESS_REPORT(,&RUNNR#,&REPORT_TYPE#)
:SET &RET# = WRITE_PROCESS(&HND#,&FILENAME#,&HOST# ,&LOGIN#,OVERWRITE)
:CLOSE_PROCESS &HND#