Property ErrorLogFile is not available for JobServer

This Error Show to me when i want to see the Properties of SQL Server Agent to my instance

troubleshoot this Error

go to Start >>>> Run >>>>> Write (Regedit)
HKEY_LOCAL_MACHINE >>>>SOFTWARE>>>>MICROSOFT>>>>MICROSOFT SQL SERVER >>>> (YOUR INSTANCE NAME)>>>>SQLSERVERAGENT >>>>double click on SQLSERVERAGENT
search in the right list on file name (ErrorLogFile) if you found it right click >>>>> Modfiy >>>>> Check the path in ValueData is true this path
if you not found this file (ErrorLogFile)
right click on SQLSERVERAGENT >>>>>New >>>> String Value
Rename the file will Create to (ErrorLogFile)
thengo to C: Drive >>>> Programme File >>>>Microsoft SQL Server >>>> (Your Instance Name) >>>>MSSQL >>>>Log >>>>SQLAGENT.OUT
then take this path and go to the file (ErrorLogFile) in the reigistration
then right click >>>> Modify >>>> put the path in Value Data . then ok
try now to open your SQL AGENT Properties .

Published by Mustafa EL-Masry

I am Microsoft database consultant working as a Database administrator for more than +10 Years I have very good knowledge about Database Migration, Consolidation, Performance Tuning, Automation Using T-SQL, and PowerShell and so many other tasks I do it in multiple customers here in KSA and as of now, I am working in Bank Albilad managing the core banking system that is hosted in SQL Server Database 8 TB. Also, I am Microsoft certified 2008 and 2016 in SQL Server (2x MCTS, 2x MCTIP, MCSA, MCSE) and I am Microsoft Certified Trainer (MCT) also I am azure Certified (AZ-900, AZ-103) also I was awarded by Microsoft Azure Heroes 3 times as (Azure Content hero, Azure Community hero and Azure Mentor) For more information check my page https://mostafaelmasry.com/about-me/ View all posts by Mustafa EL-Masry