How to Setup the Email Notificaion For Job Failure on SQL Server #sqlserver #sqldba #sqlserverdba

*****************************************************************************************
* How to Setup the Email Notificaion For Job Failure on SQL Server *
*****************************************************************************************

We will be using two ways in SQL Server
1. Using SQL Server Agent Notification
2. Using sp_send_dbmail Store Procedure

--Script:
@profile_name = 'Chiragstutorial',
@body = 'Email From Production Database Server',
@subject = 'Job has failed';

Note : Flow the Process shown in video.

😉Subscribe and like for more videos:
💛Don't forget to, 💘Follow, 💝Like, 💖Share 💙&, Comment

Thanks & Regards,
Chitt Ranjan Mahto "Chirag"
_________________________________________________________________________________________
Note: All scripts used in this demo will be available in our website.
Link will be available in description.

#ChiragTutorial
#ChiragsTutorial
#Chirags
#Chirag
#ChittRanjanMahto
#ChiragMahto
#SQLServer
#SQLServerAgent
#JobFailureNotification
#EmailNotification
#DatabaseMail
#SQLServerJobs
#SQLServerAlerts
#SQLServerMonitoring
#SQLServerAdministration
#SQLServerDBA
#SQLServerManagement
#SQLServerTutorial
#SQLServerConfiguration
#SQLServerSetup
#SQLServerMaintenance
#SQLServerBestPractices
#SQLServerTips
#SQLServerGuidance
#SQLServerHelp
#SQLServerSupport
#SQLServerTroubleshooting
#SQLServerErrorHandling
#SQLServerAutomation
#SQLServerScripting
#SQLServerTools
#SQLServerUtilities
#SQLServerManagementStudio
#SSMS
#SQLServerOperators
#SQLServerNotifications
#SQLServerEmailSetup
#SQLServerAgentJobs
#SQLServerJobMonitoring
#SQLServerJobAlerts
#SQLServerJobFailures
#SQLServerJobNotifications
#SQLServerJobManagement
#SQLServerJobConfiguration
#SQLServerJobSetup
#SQLServerJobAdministration
#SQLServerJobScheduling
#SQLServerJobAutomation
#SQLServerJobErrorHandling
#SQLServerJobTroubleshooting
#SQLServerJobSupport
#SQLServerJobTips
#SQLServerJobGuidance
#SQLServerJobHelp
#SQLServerJobBestPractices
#SQLServerJobMaintenance
#SQLServerJobMonitoringTools
#SQLServerJobAlertSetup
#SQLServerJobNotificationSetup
#SQLServerJobEmailNotification
#SQLServerJobEmailAlert
#SQLServerJobEmailSetup
#SQLServerJobEmailConfiguration
#SQLServerJobEmailManagement
#SQLServerJobEmailAdministration
#SQLServerJobEmailTips
#SQLServerJobEmailGuidance
#SQLServerJobEmailHelp
#SQLServerJobEmailSupport
#SQLServerJobEmailBestPractices
#SQLServerJobEmailMaintenance
#SQLServerJobEmailMonitoring
#SQLServerJobEmailAlertSetup
#SQLServerJobEmailNotificationSetup
#SQLServerJobEmailAlertConfiguration
#SQLServerJobEmailAlertManagement
#SQLServerJobEmailAlertAdministration
#SQLServerJobEmailAlertTips
#SQLServerJobEmailAlertGuidance
#SQLServerJobEmailAlertHelp
#SQLServerJobEmailAlertSupport
#SQLServerJobEmailAlertBestPractices
#SQLServerJobEmailAlertMaintenance
#SQLServerJobEmailAlertMonitoring
#SQLServerJobEmailAlertSetupGuide
#SQLServerJobEmailAlertConfigurationGuide
#SQLServerJobEmailAlertManagementGuide
#SQLServerJobEmailAlertAdministrationGuide
#SQLServerJobEmailAlertTipsGuide
#SQLServerJobEmailAlertGuidanceGuide
#SQLServerJobEmailAlertHelpGuide
#SQLServerJobEmailAlertSupportGuide
#SQLServerJobEmailAlertBestPracticesGuide
#SQLServerJobEmailAlertMaintenanceGuide
#SQLServerJobEmailAlertMonitoringGuide
#SQLServerJobEmailAlertSetupInstructions
#SQLServerJobEmailAlertConfigurationInstructions
#SQLServerJobEmailAlertManagementInstructions
#SQLServerJobEmailAlertAdministrationInstructions
#SQLServerJobEmailAlertTipsInstructions