I have SQL processes that clash with each other on a SQL Server table. One procedure reads from the table and other procedure truncates,inserts into and updates the table.
The second process is actually a scheduled job.
Question is that is it possible to schedule the sync job in an asynchrnous way that when value of a column status in the table named reporting_job_status is set to "Completed" SQL server agent immediately fires the SQL job ?
Right now i have it on 3 trials each scheduled after 5 minutes. So if for some reason users keep running reports then there would probably be never a moment with in those 3 trials that the value gets set to "Completed" and the scheduled can be run.