单项选择题
A.You should remove the schedule for Wednesday from Job5.
B.You should add a new Job5 schedule for Wednesday and disable it.
C.You should delete the schedule for Wednesday.
D.You should disable the schedule for Wednesday.
单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There is a stored procedure. The stored procedure implements a database maintenance process. A SQL Server Agent job should be created to that runs the stored procedure. Besides this， you must make sure that after it is completed successfully， the job is removed. What should you do？ （）
单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. A new SQL Agent job has been created by you. The job includes a Windows PowerShell job step which transfer data between servers by using the SQLCmd utility. If the job fails, you must make sure that an operator named ReactGroup is informed by receiving an e-mail. So what action should you perform to achieve this goal? （）
单项选择题 You work in a company which uses SQL Server 2008. You are the administrator of the company database. Now you are in charge of a SQL Server 2008 instance. There are user-defined stored procedures. Now you have to make sure two things, first, the names of all user-defined stored procedures must contain the prefix usp_ on all instances; second, stored procedures that do not contain this prefix cannot be created by you. So what should you do to ensure this two?（）