YouareresponsibleforimplementingmaintenancejobsonaSQLServer2005databaseserver.CertainjobsruneverySundayandotherjobsrunatthebeginningofeverymonth.Youneedtoschedulethejobsinthewaythatusestheleastamountofadministrativeeffort.Whatshouldyoudo?()
A.CreateajobschedulethatrunseverySunday.Assignweeklytaskstothisschedule.Createasecondschedulethatrunsonthefirstdayofeverymonth.Assignmonthlytaskstothisschedule.
B.Createajobforeachtaskthatrunsonceaday.UseaTransact-SQLstatementtocheckthedateanddayoftheweek.IfthedayiseitheraSundayorthefirstdayofthemonth,executethecode.
C.Createajobschedulethatrunsonceaday.Assignjobstothisjobschedule.IfthedayiseitheraSundayorthefirstdayofthemonth,executethejobs.
D.CreateajobforeachtaskthatrunsonceaweekonSunday.Addasecondjobschedulethatrunsthejobonthefirstofthemonth.
参考答案:A