6

When using Ola Hallengren's SQL Server Maintenance Solution, the job output log is going to a local directory on the SQL server. I was thinking of placing these logs on a fileserver to allow access to more people so they can review the job output.

My questions are:

  1. How can I change this location?
  2. Is there any downside to changing the location?

Thanks!

  • Ola has multiple solution, which one you are talking about. Add an example in your code. – SqlWorldWide Aug 19 '17 at 15:24
6

I’m going to reword your questions a little:

Q: Should I log Agent jobs directly to a remote file server? No, because if you lose network connectivity or the file share goes down, your Agent job could fail. Your Agent job might not require network connectivity, like an update stats job, so that failure would suck.

Q: If I want to centralize Agent job history, how should I do it? Consider logging to a table (and Ola’s scripts support this too.) That way you can centralize the data in whatever method you like, like replication or log shipping. I like logging to a DBA utility database, and then restoring that from all my servers to one central server daily. Then I use union all views to combine the data from all my servers. It’s not up to the second, though.

| improve this answer | |
  • @cspell you're welcome, glad I could help. – Brent Ozar Aug 21 '17 at 11:25
3

I would actually suggest a central log management such as Logstash using filebeat to read logs. This would also not only allow you to set alerts on critical errors but also provide easy way to analyse output and even build dashboards which is much easier to review than reading potentially hundreds of text files. Olla's scripts log start and end time and you could possibly extract that into a chart to track timing of how long it takes to backup each db on daily basis for example.

| improve this answer | |
  • Interesting, i'll check it out – cspell Aug 20 '17 at 11:25

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.