Thank you for your reply cmille19, the job works fine for generating the csvs but after running run-smo step im getting this:

The step did not generate any output. Process Exit Code 0. The step succeeded.

(i.e. I am getting this error when running the single job step)

The logs are also fine and the jobstep type is set to cmdexec

(execution policy is set to remotesigned)