'Unable to open Step output file' error when an SQL job runs
Symptoms
'Unable to open Step output file' error when an SQL job runs
Error/warning messages
English: Unable to open Step output file. The step failed.
French: Impossible d'ouvrir le fichier de sortie de l'étape. L'étape a échoué.
Reason
The step was configured to save the job outcome into a text file on the disk. Either the file path is wrong or the SQL Agent account does not have sufficient access rights to create or edit the specified output file.
Resolution
Correct the file path for the output file or grant the user account with the required access rights.