Configure Database Mail, Operator and Notifications in SQL Server

Поділитися
Вставка
  • Опубліковано 26 жов 2024

КОМЕНТАРІ • 55

  • @sankarn9046
    @sankarn9046 10 років тому

    Thanks Keshav you saved my ass a second time Fantastic video talks not only about setting up email but also how to configure notification when a job succeeds or fails.

  • @felixlam270
    @felixlam270 5 років тому

    Thk for uploading the method using mail for alerting the job ..your contribution for improving the knowledge of sqlserver is very appreciated

  • @goyaluful
    @goyaluful 11 років тому +1

    Kesav great demo I was able to configure database mail without knowing abcd of sql server Thanks so much

  • @firozmnshi
    @firozmnshi 12 років тому +1

    Very nice share Keshav. This is exactly what I was looking for. Thanks indeed, and keep up the good work.

  • @sicmike2g
    @sicmike2g 4 роки тому

    @7:45 , this was the step I was missing all along. Thanks so much man.

  • @EddieKumarShrivastava2
    @EddieKumarShrivastava2 3 роки тому

    Still applicable & great reminder. Thanks for posting.

  • @kevinalves7694
    @kevinalves7694 2 роки тому

    Very nice and helpfull. I add on my case the feedback to Teams. I also get the notification on Teams

  • @venkateshtandra7013
    @venkateshtandra7013 12 років тому

    Hi Keshav,
    Really helping to me.Thankq so much for share this video

  • @FlashRiver
    @FlashRiver 12 років тому

    Excellent lesson Keshav, thank you :)

  • @SAIBABUSARISASRUJA93
    @SAIBABUSARISASRUJA93 8 років тому

    Thanks Keshav garu and how to configure notification when a
    job succeeds or fails in Signal Job

  • @vipinmishra1911
    @vipinmishra1911 9 років тому +2

    Hi try to setup mail but i got this error can u help me to resolve this error
    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 1 (2015-01-22T13:03:38). Exception Message: Cannot send mails to mail server. (The SMTP server requires a secure connection or the client was not authenticated. The server response was: 5.7.0 Must issue a STARTTLS command first. rf10sm5103041pdb.21 - gsmtp). )

  • @oupamster
    @oupamster 11 років тому

    hi Keshav,
    highly interesting posts. tnx man.

  • @drackster7438
    @drackster7438 9 років тому

    una duda! como puedo omitir el certifiado de seguridad cuando este es invalido?? me marca el siguiente error :
    Mensaje de excepcion: no se pueden enviar los mensajes de correo al servidor de correo. (el certificado remoto no es válido según el procedimiento de validación)
    gracias!!

  • @CARLOSRAMIREZ-kb4hp
    @CARLOSRAMIREZ-kb4hp 3 роки тому

    thanks for the video, it was really useful

  • @NMOSAM
    @NMOSAM 12 років тому

    thanks a lot keshav..this is really helpful

  • @tvsnmurthy2370
    @tvsnmurthy2370 5 років тому

    Hi.. Thanks keshav...
    How to send multiple query attachments using sql server msdb senddbmail procedures.. Please reply to this solution

  • @dwaipayanbiswas2391
    @dwaipayanbiswas2391 4 роки тому

    Email alert from MySQL database if database row is updated. Can u share how to do that.

  • @ajeetsinghsaluja9496
    @ajeetsinghsaluja9496 6 років тому

    what to check if i dont get any option from SSMS to start stop SQL agent service.i am getting them greyed out

  • @taufikaldanmaulana6228
    @taufikaldanmaulana6228 3 роки тому

    smtp feature must enable on the server ?

  • @vjekodamjanovic2439
    @vjekodamjanovic2439 9 років тому

    Excellent video, helped a lot! Thank you.

  • @samarthmuddi8961
    @samarthmuddi8961 3 роки тому

    The mail could not be sent to the recipients because of the mail server failure. (Sending Mail using Account 2 (2021-03-15T15:47:38). Exception Message: Could not connect to mail server. (A connection attempt failed because the connected party did not properly respond after a period of time, or established connection failed because connected host has failed to respond [2404:6800:4003:c03::6c]:467).
    )

  • @tpatel7189
    @tpatel7189 11 років тому

    Is there any way to get notify if the SQL server failed via email without using third party tool?

  • @azzeddineelouadi
    @azzeddineelouadi 10 років тому

    hi ! at 3:50 in basic authentication .. is it gmail password ??? thanks before :)

  • @animeja
    @animeja 10 років тому

    Very good explanation your friend, I learned a lot.
    Set up alerts in SQL here on my servers and everything worked.
    Keshav, you have some video that explains the different types of alerts?
    Thank you for sharing some of your knowledge
    Robinson
    São Paulo - Brazil

  • @KeshavSingh83
    @KeshavSingh83  11 років тому

    I am glad it helped you.

  • @afzaalawan
    @afzaalawan 3 роки тому

    great work.. thanks

  • @alpeshksuthar
    @alpeshksuthar 11 років тому

    This is cool stuff. Helped lot!

  • @anjipavuluri8659
    @anjipavuluri8659 9 років тому

    realy nice . good explanation. thanks dude... :)

  • @joelradon
    @joelradon 9 років тому

    Nice video. Thanks!

  • @davidlarter3828
    @davidlarter3828 9 років тому

    Nice work, thank you sir!

  • @sharpe7852
    @sharpe7852 11 років тому

    Very good video! Thanks!

  • @miyooutdoor3895
    @miyooutdoor3895 10 років тому

    will it work in SQL 2000? TIA

  • @krupaaloor1596
    @krupaaloor1596 11 років тому

    Nice video !

  • @dileepkumarturlapati3313
    @dileepkumarturlapati3313 6 років тому

    Thank you brother

  • @Biohazard94.
    @Biohazard94. 2 роки тому

    thank you :D

  • @Jimmy-ym2fg
    @Jimmy-ym2fg 10 років тому

    perfec doc :)
    gracias.

  • @pablors001
    @pablors001 10 років тому

    thanks, good video!!

  • @manoharchowdarycherukuri7088
    @manoharchowdarycherukuri7088 3 роки тому

    Pls Post the T-Script for this process.

  • @benyaminmohamadi7877
    @benyaminmohamadi7877 4 роки тому

    thank youuuuuuuuuuuuuuuuuuu :)

  • @inthestart1
    @inthestart1 10 років тому

    thnxx fella

  • @manoharchowdary1173
    @manoharchowdary1173 3 роки тому

    I want t script for this task.

  • @gramaswaroop532
    @gramaswaroop532 8 років тому

    sir not recive the mail ....

  • @JanselFernandez
    @JanselFernandez 7 років тому

    Thanks!

  • @RaviRanjanKumarraviranjanarya
    @RaviRanjanKumarraviranjanarya 8 років тому

    Thanks alot

    • @elektrojc
      @elektrojc 8 років тому

      +Ravi Ranjan Kumar Ravi do you know if i can configurate more than one e mail in the Operators....can i separate the mails for example one@gmail.com, two@gmail.com...etc

    • @RaviRanjanKumarraviranjanarya
      @RaviRanjanKumarraviranjanarya 8 років тому

      +Juan AR Sorry Juan... I'm also new to this....

  • @andrewbosco15
    @andrewbosco15 10 років тому

    Good...

  • @megan2484
    @megan2484 7 років тому

    The Tab SQL Server Agent is not there for me. Anyone can help?

    • @ajaysql2599
      @ajaysql2599 4 роки тому

      you are using express edition possibly

  • @onlytest5332
    @onlytest5332 2 роки тому

    I am Watching This In 2022😅

  • @digidimasta
    @digidimasta 6 років тому

    At 5:50 you can see text:
    "You ruined my life Saumya............ I hate you like HELL".
    How damn you need to be to show this in a video lol.