I’m a huge fan of Ola Hallengren‘s free utility scripts. If you aren’t familiar with it, it’s a great tool to manage backups, index maintenance and the overall health of your SQL Servers. It is utilized around the globe and it is completely free.
Although his script is very thorough I still like to tweak and One of the things that I tend to change is the way that the log file for each respective job is named. By default, the file name is configured in the following format: