SqlJob execution on Insert

• Priya004

  Ten Centuries

  Points: 1368

  More actions

  September 8, 2014 at 4:29 am

  #295932

  Hi,

  Is there any way to tell the sqlserver agent that sqljob should run only when inserts done in a table?

  Thanks!

• hrushi2575-1023267

  Newbie

  Points: 3

  More actions

  September 8, 2014 at 5:20 am

  #1743824

  Call the job inside a after tigger

• Grant Fritchey

  SSC Guru

  Points: 399020

  More actions

  September 8, 2014 at 6:36 am

  #1743838

  A trigger is probably a good choice (depending on what the job does). Another approach would be to have the job run on a regular basis, once a minute or something, then have it check for the existence of data in the table, or new data in the table. That won't be real time though.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning