case statement issue

• mtz676

  SSCrazy Eights

  Points: 9180

  More actions

  October 19, 2020 at 2:18 pm

  #3798850

  SELECT CASE

  WHEN EXISTS ( SELECT name,enabled FROM msdb.dbo.sysjobs

  WHERE name = 'Myjob' )

  THEN 'Exists'

  ELSE 'Does not exist'

  END as 'SQL Job'

  How do I add the enabled column to the output here?

  If job exists then print 'Exists' and its status as enabled or disabled as in the sysjobs table

  if job does not exist then print 'Does not exist' and under the status column as 'No job no status'

• Cebisa

  SSC Enthusiast

  Points: 151

  More actions

  October 19, 2020 at 2:30 pm

  #3798859

  When exists(

  Select case when [enabled]=1 then [name] + ' Enabled' else [name] + ' Not Enabled' End

  )

• jcelko212 32090

  SSCrazy Eights

  Points: 9294

  More actions

  October 23, 2020 at 9:01 pm

  #3800597

  CASE is  an expression, not a statement. Basics, please.

  Please post DDL and follow ANSI/ISO standards when asking for help.