Skip to content

SQL-Articles

On Premise and Cloud Database Knowledge Base

Tag: trigger

Trigger to Check Job failures

I was trying to find a alert which could fire immediately upon any of the job failure in the server to send an email. Unfortunately I couldn’t find any the alert related to this. So I thought of writing a DML trigger which should fire immediately when an entry is inserted in sysjobhistory table on… Continue reading Trigger to Check Job failures

Published March 8, 2009
Categorized as Scripts Tagged administration, job failure, trigger

Recent Posts

  • CSSUG February 2020 Meet
  • CSSUG January 2020 Meet
  • CSSUG November 2019 Meet
  • CSSUG October 2019 Meet
  • Dropping a Subscriber from AG Publisher
SQL-Articles
Proudly powered by WordPress.