I can able to reproduce the Issue. Can you please check the sql warehouse has permissions to run the query? below I have tested with a sql warehouse doesn't have permissions to run the query and sql warehouse has permissions to run the query.

Job Task Details:

Failed Run and Successful Run:

Failed Run:

 Successful Run: