SQL JOB schedule: how to skip certain month-CodePudding

I need a report that runs once on the following month below: JAN,FEB,APR,MAY,JUL,AUG,OCT,NOV (essentially skipping MAR, JUN, SEP and DEC)

and this is how I do it (I had to have two schedules to achieve it: See screenshot below). and My question does my two-schedule method will get me what I need? is there a better way? Will this still work in 2024, 2025 and so on?

thanks

The only difference between the schedule is the start date.

THE FIRST Schedule ( I am hoping this report will run on JAN APR JUL OCT)

The second Schedule: ( And the second schedule, I am hoping it will run on FEB MAY AUG NOV)

CodePudding user response：

Simply have a single job that executes monthly and in the t-sql job step

if month(getdate()) in (1,2,4,5,7,8,10,11)
begin
  exec...
end