首页 资讯 YouareresponsibleforimplementingmaintenancejobsonaSQLServer2

YouareresponsibleforimplementingmaintenancejobsonaSQLServer2

YouareresponsibleforimplementingmaintenancejobsonaSQLServer2005databaseserver.CertainjobsruneverySundayandotherjobsrunatthebeginningofeverymonth.Youneedtoschedulethejobsinthewaythatusestheleastamountofadministrativeeffort.Whatshouldyoudo?()

A.CreateajobschedulethatrunseverySunday.Assignweeklytaskstothisschedule.Createasecondschedulethatrunsonthefirstdayofeverymonth.Assignmonthlytaskstothisschedule.

B.Createajobforeachtaskthatrunsonceaday.UseaTransact-SQLstatementtocheckthedateanddayoftheweek.IfthedayiseitheraSundayorthefirstdayofthemonth,executethecode.

C.Createajobschedulethatrunsonceaday.Assignjobstothisjobschedule.IfthedayiseitheraSundayorthefirstdayofthemonth,executethejobs.

D.CreateajobforeachtaskthatrunsonceaweekonSunday.Addasecondjobschedulethatrunsthejobonthefirstofthemonth.

参考答案:A

本文来自网络,不代表煤炭资讯立场。转载请注明出处: http://www.mtxh.cn/zx/414299.html
上一篇
下一篇

作者: Anita

为您推荐

返回顶部