This job already has one schedule that runs on the first of the month.
However, we need to run the job on a different schedule if the first of the month falls on a Sunday.
It appears to me that the SQL Server Agent Job Properties Scheduler GUI is not flexible enough to handle this type of schedule. I am continuing to research this items.
Any thoughts or examples (if powershell is needed) would be appreciated. We are running SQL Server 2019 on Windows Server 2019.
To clarify, the job runs on the first of the month starting at 5 A.M. If the first of the month falls on a Sunday, we need the job to start at 6:15 A.M. So, maybe I can use something like:
case datepart(dw,getdate()) = 1 then 'execute one job schedule' else 'execute another job schedule' end.