Executing webjobs via SQL server Stored Procedure

Question

I have a very simple C# console exe. My code deletes a blob from a particular blob storage. It takes a couple of command-line arguments - container name & blob name and deletes the blob whenever triggered. Now, I want to schedule this exe as a webjob.

I have a couple of questions -

1. How can I manually trigger this webjob since it takes command line arguments?
2. Is there any way that I can trigger this webjob via a SQL server stored procedure?

Answer 1

You can use the stored procedure to send http requests to fulfill your needs.

Steps

1. You can use the Kudu Webjob API to invoke your function.

2. Create HttpRequest Method in sql server.

   Related post

   How can I make HTTP request from SQL server?