A、Create a job schedule that runs every Sunday.Assign weekly tasks to this schedule.Create a second schedule that runs on the first day of every month. Assign monthly tasks to this schedule.
B、Create a job for each task that runs once a day. Use a Transact-SQL statement to check the date and day of the week. If the day is either a Sunday or the first day of the month， execute the code.
C、Create a job schedule that runs once a day. Assign jobs to this job schedule. If the day is either a Sunday or the first day of the month， execute the jobs.
D、Create a job for each task that runs once a week on Sunday. Add a second job schedule that runs the job on the first of the month