Hi guys, I am struggling with an error in SQL agent. After having create dozens of jobs and steps and schedules without any problem, suddenly I got this error when I tried to insert, edit, etc. any steps (and to run job monitor too): Attempted to read or write protected memory. This is often an indication that other memory is corrupt. (mscorlib)" which seems to be a message used for several and different issues. I unistalled and reinstalled SSMS with the latest version but nothing. The same SSMS was working correctly up to Thursday. I was suggested to try with Azure Studio (SQL Agent extension) and in effect, the issue remain (no step created) but I have a different error:
Job update failed 'Microsoft.SqlServer.Management.Smo.FailedOperationException: Attempt to retrieve data for object failed for Server 'xxxxx.com'.
---> Microsoft.SqlServer.Management.Smo.SmoException: Invalid Urn filter on server level: filter must be empty, or server attribute must be equal with the true server name.
at Microsoft.SqlServer.Management.Smo.Server.CheckValidUrnServerLevel(XPathExpressionBlock xb)
at Microsoft.SqlServer.Management.Smo.Server.GetSmoObjectRec(Urn urn)
at Microsoft.SqlServer.Management.Smo.Server.GetSmoObjectRec(Urn urn)
at Microsoft.SqlServer.Management.Smo.Server.GetSmoObjectRec(Urn urn)
at Microsoft.SqlServer.Management.Smo.Server.GetSmoObject(Urn urn)
--- End of inner exception stack trace ---
at Microsoft.SqlServer.Management.Smo.Server.GetSmoObject(Urn urn)
at Microsoft.SqlTools.ServiceLayer.Agent.JobData.get_Job() in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Agent\Jobs\JobData.cs:line 689
at Microsoft.SqlTools.ServiceLayer.Agent.JobData.CheckAndLoadGeneralData() in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Agent\Jobs\JobData.cs:line 763
at Microsoft.SqlTools.ServiceLayer.Agent.JobData..ctor(CDataContainer data, AgentJobInfo jobInfo, ConfigAction configAction) in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Agent\Jobs\JobData.cs:line 639
at Microsoft.SqlTools.ServiceLayer.Agent.AgentService.CreateJobData(String ownerUri, String jobName, CDataContainer& dataContainer, JobData& jobData, ConfigAction configAction, AgentJobInfo jobInfo) in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Agent\AgentService.cs:line 1185
at Microsoft.SqlTools.ServiceLayer.Agent.AgentService.<>c_DisplayClass40_0.<<ConfigureAgentJob>b_0>d.MoveNext() in D:\a\1\s\src\Microsoft.SqlTools.ServiceLayer\Agent\AgentService.cs:line 916'
Any suggestion in how I can resolve the issue?