Which stored procedure should you use?

You have Microsoft SQL Server on a Microsoft Azure virtual machine.
You create a SQL Server Agent job by using the following statement.

You need to send an email message if the job fails.
Which stored procedure should you use?
A. msdb.dbo.sp_update_alert
B. msdb.dbo.sp_add_jobstep
C. msdb.dbo.sp_add_notification
D. msdb.dbo.sp_help_alert
E. msdb.dbo.sp help jobactivity

microsoft-exams

Leave a Reply

Your email address will not be published. Required fields are marked *


The reCAPTCHA verification period has expired. Please reload the page.