How to create a app background job for multi-tenancy Azure App
up vote
1
down vote
favorite
I would like to create a background task for my Azure Saas application. The task is to look at the date field of an Azure SQL database table and take action based on the the result. The task should run once a day against all SaaS tenants. I have multi-tenancy with ShardMapManager with a separate Azure SQL database per tenant. I cannot find any information on how to set up WebJobs or Web functions to cycle through each of the tenant databases automatically. Would Elastic Job be involved which will run through the different databases? The problem is that it only uses T-SQL code. Would a combination of EasticJobs and WebJobs be required? Basically how can I create a background job that would be processed against all tenant databases?
azure multi-tenant azure-webjobs asked Nov 10 at 23:28
RPollack
1014
add a comment |
up vote
1
down vote
favorite
I would like to create a background task for my Azure Saas application. The task is to look at the date field of an Azure SQL database table and take action based on the the result. The task should run once a day against all SaaS tenants. I have multi-tenancy with ShardMapManager with a separate Azure SQL database per tenant. I cannot find any information on how to set up WebJobs or Web functions to cycle through each of the tenant databases automatically. Would Elastic Job be involved which will run through the different databases? The problem is that it only uses T-SQL code. Would a combination of EasticJobs and WebJobs be required? Basically how can I create a background job that would be processed against all tenant databases?
azure multi-tenant azure-webjobs asked Nov 10 at 23:28
RPollack
1014
add a comment |
up vote
1
down vote
favorite
up vote
1
down vote
favorite
I would like to create a background task for my Azure Saas application. The task is to look at the date field of an Azure SQL database table and take action based on the the result. The task should run once a day against all SaaS tenants. I have multi-tenancy with ShardMapManager with a separate Azure SQL database per tenant. I cannot find any information on how to set up WebJobs or Web functions to cycle through each of the tenant databases automatically. Would Elastic Job be involved which will run through the different databases? The problem is that it only uses T-SQL code. Would a combination of EasticJobs and WebJobs be required? Basically how can I create a background job that would be processed against all tenant databases?
azure multi-tenant azure-webjobs asked Nov 10 at 23:28
RPollack
1014
I would like to create a background task for my Azure Saas application. The task is to look at the date field of an Azure SQL database table and take action based on the the result. The task should run once a day against all SaaS tenants. I have multi-tenancy with ShardMapManager with a separate Azure SQL database per tenant. I cannot find any information on how to set up WebJobs or Web functions to cycle through each of the tenant databases automatically. Would Elastic Job be involved which will run through the different databases? The problem is that it only uses T-SQL code. Would a combination of EasticJobs and WebJobs be required? Basically how can I create a background job that would be processed against all tenant databases?
azure multi-tenant azure-webjobs azure multi-tenant azure-webjobs asked Nov 10 at 23:28
RPollack
1014
asked Nov 10 at 23:28
RPollack
1014
asked Nov 10 at 23:28
RPollack
1014
asked Nov 10 at 23:28
RPollack
1014
asked Nov 10 at 23:28
RPollack
1014
1014
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
0
down vote
I think you could try going with a Timer trigger for Azure Functions and just place the code that iterates through the databases and perform the required tasks inside as Azure Function.
I would even go further to separate the process into two different functions:
Iterating through the databases
Perform the required logic per database
Hope it helps!
answered Nov 12 at 6:50
Itay Podhajcer
1,067212
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
0
down vote
I think you could try going with a Timer trigger for Azure Functions and just place the code that iterates through the databases and perform the required tasks inside as Azure Function.
I would even go further to separate the process into two different functions:
Iterating through the databases
Perform the required logic per database
Hope it helps!
answered Nov 12 at 6:50
Itay Podhajcer
1,067212
add a comment |
up vote
0
down vote
I think you could try going with a Timer trigger for Azure Functions and just place the code that iterates through the databases and perform the required tasks inside as Azure Function.
I would even go further to separate the process into two different functions:
Iterating through the databases
Perform the required logic per database
Hope it helps!
answered Nov 12 at 6:50
Itay Podhajcer
1,067212
add a comment |
up vote
0
down vote
up vote
0
down vote
I think you could try going with a Timer trigger for Azure Functions and just place the code that iterates through the databases and perform the required tasks inside as Azure Function.
I would even go further to separate the process into two different functions:
Iterating through the databases
Perform the required logic per database
Hope it helps!
answered Nov 12 at 6:50
Itay Podhajcer
1,067212
I think you could try going with a Timer trigger for Azure Functions and just place the code that iterates through the databases and perform the required tasks inside as Azure Function.
I would even go further to separate the process into two different functions:
Iterating through the databases
Perform the required logic per database
Hope it helps!
answered Nov 12 at 6:50
Itay Podhajcer
1,067212
answered Nov 12 at 6:50
Itay Podhajcer
1,067212
answered Nov 12 at 6:50
Itay Podhajcer
1,067212
answered Nov 12 at 6:50
Itay Podhajcer
1,067212
1,067212
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53244425%2fhow-to-create-a-app-background-job-for-multi-tenancy-azure-app%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
