Solomon Rutzky has found patterns which cause SQL Agent step outputs not to write any details:
And that’s when it happened: I started getting a value back from
QUOTENAME(ORIGINAL_DB_NAME()), and not just the square brackets with nothing between them. The name of a database was now between the square brackets. Why wasn’t that showing up before?
Solomon knows the how but not the why in this case.