<div>
<blockquote>
I have an SQL server table (ID, URL, Testing Result) that stored hyperlinks (URL) for different websites and I have a C# code that will check each URL if it's working or broken.
</blockquote>
How frequent are you doing this?<br />
-how frequent for data updates?<br />
-how frequent for data checks?<br />
<br />
you may consider to use SSIS or some ETL jobs for URL verifications
</div>


<div>
Thanks a lot Ryan.<br />
<br />
I got data update once each month and I verify it after that.
</div>


<div>
so if you only update once per month, it means the process is approx 4000+ tasks per month.<br />
<br />
i would recommend you to use SSIS or create a custom separate program (C# etc, which you can defined it as an ETL program etc) to do the tasks IF you don't need to verify the URL instantly after the data was updated.<br />
<br />
also, you may define a rule IF the URL data is not changed, do you want to verify these data as well?
</div>


<div>
If the data is not changed so no verification is needed.<br />
<br />
Could you please explain me how to use SSIS or custom separate program (C# OR ETL program) to do that ?
</div>


<div>
Thanks a lot Ryan for your help
</div>


<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have an SQL server table (ID, URL, Testing Result) that stored hyperlinks (URL) for different websites and I have a C# code that will check each URL if it's working or broken.<br />
<br />
My question is:<br />
How to trigger this code inside the SQL server and write the result of each URL in the same table? Keeping in mind that I have more than 4000 URLs.<br />
<br />
Please explain me the steps one by one and thanks in advance.<br />
<br />
Harreni
</div>
</div>


Hi Experts,

I have an SQL server table (ID, URL, Testing Result) that stored hyperlinks (URL) for different websites and I have a C# code that will check each URL if it's working or broken.

My question is:
How to trigger this code inside the SQL server and write the result of each URL in the same table? Keeping in mind that I have more than 4000 URLs.

Please explain me the steps one by one and thanks in advance.

Harreni

Trigger C# code inside the SQL Server

C# is an object-oriented programming language created in conjunction with Microsoft’s .NET framework. Compilation is usually done into the Microsoft Intermediate Language (MSIL), which is then JIT-compiled to native code (and cached) during execution in the Common Language Runtime (CLR).

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.