If you have a requirement to carefully have the output file against each sql agent job step, you can use this script. If incase, there are many sql agent jobs and by any reason if any of the step does not have proper o/p file, this script can automatically create the o/p file.
2019-05-03 (first published: 2016-05-20)
This script adds empty first step for every job for easier job history viewing.
2015-12-28 (first published: 2015-12-10)
Generate an HTML page with the timeline of your SQL jobs using Google graph and sp_send_dbmail
2016-10-28 (first published: 2015-07-28)
Query to find the Job Output file location at each job step.
This helps if you want to find out the location of each output file of jobs to find out whether those are going to the right location.
2019-05-03 (first published: 2015-04-24)