locked
SQL SERVER JOBS STATUS ALERTS VIA MAIL RRS feed

  • Question

  • HI,

    I want to automate mail the all the job status to my mail , but it should be happen without configuring dbmail, could you please provide me best way to do.

    note : In my environment there is no dbmail enbled.

    Tuesday, January 24, 2017 6:56 AM

All replies

  • Hello Ashok Jason,

    Then you'll go from the difficult path.

    You can make the results of the jobs written to the Windows Application Event Log and capture them via a customized method or use a 3rd party monitoring tool. The result of the jobs in the event log would be something like:

    "SQL Server Scheduled Job 'syspolicy_purge_history' (0x35AC4FC0B0CAB94BB92A5AFC73B7F892) - Status: Succeeded - Invoked on: 2017-01-24 11:02:45 - Message: The job succeeded.  The Job was invoked by User WIN-I7VEIF1DJM7\Ekrem Onsoy.  The last step to run was step 3 (Erase Phantom System Health Records.).  The job was requested to start at step 1 (Verify that automation is enabled.)."

    You'll capture them according to your business rules and make the monitoring tool sent the mail to the relavent contacts.


    http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @EkremOnsoy

    Tuesday, January 24, 2017 8:06 AM