The paths all being the same between two instances isn't right. The subsystem_dll paths should be different between instances on the same server.

I have no idea how the instance root...

The other thing I keep forgetting...when you restarted SQL Agent, look at the Out file, error log and see if there are errors on startup for the SSIS subsystem. I...

I have seen the same behavior with two instances so it's not as weird as it may seem. The syssubsystems table gets populated based on entries in the registry. It...

If the subsystems data appears correct and all the paths are fine, You can also get the error with permissions issues, not just messed up subsysystems. Check the windows log...

Interesting as that is exactly what is being done in that article so not sure how it wouldn't apply. The error seems to indicate the subnets aren't talking to each...

And what are the details in the SQLAgent.out file when the job fails? You would also want to look at when Agent started, not just when the job fails as...

If and when it shows up again, you may want to query msdb..sysjobs as well. That will at least tell you when the job was created and the owner which...

Jonathan Kehayias has a good article on setting up multi-subnets as well as the routing between the subnets for AGs and Clustering. Not sure if it helps with whatever all...

I'd do a DBCC CHECKDB of all the databases. Also try a backup to a network drive or another physical drive if that's feasible to see if you still get...

That format file doesn't match up with your query you are using. The format file you have is for 11 columns but your query indicates you are only exporting one...

I believe the issue you are running into is that SYSDATETIMEOFFSET() is not Daylight Savings Time aware.

How you handle the difference depends on numerous things (what you are doing...

Actually dbcc opentran could still not give you the results you need since it's for the current database only.

Did you query sysprocesses where open_tran >0

I would also try this...

What is the output you get when you run:

DBCC OPENTRAN

Sue

I've done in before in using the MAP tool, worked pretty well. This MS blog has some info on using it:

https://blogs.msdn.microsoft.com/markm/2015/02/17/inventorying-sql-servers-with-the-microsoft-assessment-and-planning-toolkit-map/

Sue

I don't think there is anything native to SSIS for this and I'm not sure this is really an SSIS task as much as a coding task. But it doesn't...