So I have a job that I would like to have run on the first friday of a fiscal calendar. In this case, the first friday of the fiscal calendar month does not always match up with the actual calendar month. Thus, I need to have the job run on specified dates that are generated by the fiscal calendar dates.
I do have a list of the dates that it needs to be run on, but I'm unsure on how exactly to implement this logic. On the SSMS interface, I don't see anywhere that we can define a custom schedule.
From my understanding I would have to somehow create a custom schedule off of a fiscal calendar table, and then use that in the job. Is that correct? How would I go about doing something like this?