if exists(jobschedule)???

• richard.noordam

  SSCrazy

  Points: 2691

  More actions

  April 13, 2012 at 8:39 am

  #267324

  i can create a job schedule, i can alter a job schedule, I can delete a job schedule....

  I'm assuming there is an easy TSQL way to see if a job schedule exists for a specific job... but I've pulled a bone and can't seem to find it.

  I'm working with an SSIS package, that needs to self schedule for the next quarterly run. I would like to have the SSIS package so an SQL Task to tell me if there is an existing schedule for the job.

  If yes

  {

  Alter the Job Schedule

  } Else

  Create the Job Schedule

  }

  now that's easy to do if i can determine if a schedule exists, and drop true/false into a variable and the branch the package to run one or the other commands.

  I'm still searching.

  Thanks!

• richard.noordam

  SSCrazy

  Points: 2691

  More actions

  April 13, 2012 at 8:42 am

  #1473282

  DOH! found it

  SELECT job_id, [name] FROM msdb.dbo.sysjobs;

  well not quite.

  gives me jobs... not schedules.... will keep looking, it has to be similar.

• richard.noordam

  SSCrazy

  Points: 2691

  More actions

  April 13, 2012 at 8:51 am

  #1473290

  SELECT count(*) FROM msdb.dbo.sysschedules where name = @ScheduleName

  gets a line count that will tell me what I need.

  sry to bother, figured it out.