I changed the WHERE condition to look for jobs names ending in ‘FULL’ and which executed a ‘sqlcmd’ statement:
The query result:
This list allows me to easily compare the commands executed.
E.g. I saw that on line 3 there was as parameter with value 47, whereas on line 4 I had the same parameter with value 48.
The LogToTable parameter for the instance SQL1\STORE has value ‘N’, whereas this parameter has value ‘Y’ for the SQL1\PRD instance.