SQLDBA- Get the jobs list running with 32 Bit

 

Hi, 

We have an issue with CPU spikes   and we observed that the SQL server integration services execute package utility 32 is  consuming high CPU. So, we  have to find out  which job is running with 32 bit. 

Below query  will help us figure out what  jobs causing the  issue. 

USE msdb;

GO

SELECT * FROM (

SELECT

    j.name        AS job_name,

    js.step_id,

    js.step_name,

    js.subsystem,

    js.command,

    CASE 

        WHEN js.command LIKE '%/X86%' THEN 'Yes'

        ELSE 'No'

    END AS runs_32_bit,

    js.last_run_outcome

,js.flags 

FROM dbo.sysjobsteps js

JOIN dbo.sysjobs j

    ON js.job_id = j.job_id

WHERE js.subsystem = 'SSIS'

)a WHERE runs_32_bit='yes'

--ORDER BY j.name, js.step_id;