T sql question

• dan_27

  SSC Veteran

  Points: 259

  More actions

  July 27, 2018 at 9:37 am

  #373917

  How can I do this?
  I want to create a store proc which execute the result of:
  Select name from sysjobs where name like 'myjobABC%'
  Another words just say the result of above is name = "myjobABC02018"
  then I want
  EXEC dbo.sp_start_job 'myjobABC02018'

• drew.allen

  SSC Guru

  Points: 77014

  More actions

  July 27, 2018 at 9:44 am

  #1999265

  Please don't start multiple threads on the same topic. It fragments the discussion.

  Please post responses to How to Execute SQL Agent Job Using Wildcard.

  Drew

  J. Drew Allen
  Business Intelligence Analyst
  Philadelphia, PA