September 8, 2014 at 4:29 am
Hi,
Is there any way to tell the sqlserver agent that sqljob should run only when inserts done in a table?
Thanks!
September 8, 2014 at 5:20 am
Call the job inside a after tigger
September 8, 2014 at 6:36 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply