<div>
<div class="content wysiwyg-content">
Experts,<br />
<br />
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. <br />
The second process is actually a scheduled job. <br />
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 &quot;Completed&quot; SQL server agent immediately fires the SQL job ? <br />
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 &quot;Completed&quot; and the scheduled can be run.
</div>
</div>


Experts,

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.

Executing asynchronous call

Experts,

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 &quot;Completed&quot; 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 &quot;Completed&quot; and the scheduled can be run.

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

Microsoft SQL Server

A database report is the formatted result of database queries and contains useful data for decision-making and analysis. Most good business applications contain a built-in reporting tool; this is simply a front-end interface that calls or runs back-end database queries that are formatted for easy application usage.