32-bit runtime flag in SQL Agent - msdb location

Question

Does anyone know if the 32-bit runtime flag in the 'Configuration' > 'Advanced' tab within a job step has a location in msdb (or elsewhere)? I'm looking to set the flag as part of an automated deployment.

Answer 1

Its located in command in sysjobsteps as an inline parameter. The following will return any 32bit jobs you have:

 USE msdb;
 GO

 SELECT *
 FROM dbo.sysjobsteps
 WHERE subsystem = 'SSIS'
   AND command LIKE '%/x86%';