0

I need a job to run on the 2nd and 4th Thursday of every month. I know I can set up a job to run every two weeks but that logic doesn't work when a month eventually hits a five week span. Is it possible to set this up using the SQL Server Agent Schedule? If not, does anyone recommend another method?

Gordon Linoff
  • 1,242,037
  • 58
  • 646
  • 786
justair07
  • 37
  • 8

1 Answers1

2

Create two schedules on the job, one that runs on the second Thursday, and one that runs on the fourth.

Under the Frequency heading on the Scheduler, change the Occurs drop down to Monthly to get to the options you need.

Eric Brandt
  • 7,886
  • 3
  • 18
  • 35