-1

I want to run a SQL Server Agent job every first day of shamsi (persian) month.

Thom A
  • 88,727
  • 11
  • 45
  • 75
alinn
  • 83
  • 8
  • 6
    Build your own calendar table, scheduled your job to execute daily, checks for firs day of the month based on your calendar and to decide to execute the job or not – Squirrel Sep 18 '22 at 07:54

1 Answers1

1

You must schedule the job as Daily and first of your query check that if today is the first day of shamsi month then continue else exit.

Meyssam Toluie
  • 1,061
  • 7
  • 21