Correct version to make it work on a case sensitive server

• Flemming_Thor

  Old Hand

  Points: 302

  More actions

  February 18, 2014 at 12:10 am

  #289636

  USE msdb;

  SELECT sysjobs.name AS 'JobName',

  sysjobsteps.step_id AS 'Step#',

  sysjobsteps.command AS 'SSISLocation'

  FROM sysjobs

  INNER JOIN sysjobsteps

  ON sysjobs.job_id = sysjobsteps.job_id

  WHERE [dbo].[sysjobsteps].[subsystem] = 'SSIS'

  ORDER BY 1