sqlsql-serversql-job

Run Sql Job in The first day of every shamsi month (persian date)

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

Solution

  • 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.