Windows or web application for running long running store procedure

Question

1.00/5 (1 vote)

See more:

When data collected we restore of database backup file to another server where I am executing some store procedures sequentially.As procedure executing time from 25 mins to 7 hours approx.But now we are now making this task should run from UI.I want to know which is proper way to execute this long running procedures from UI whether Windows application or Web Application?After procedure executed successfully we again restore database to live server.

What I have tried:

Right now I am running this procedure on server directly by execute command on SQL Server.But this process(task) is more tedious and complex.This takes long time and causing issues when some times process wrongly executed (e.g.- due to wrong parameter ...etc). For this I have created one windows application but as database is on another server we need to install this application on server also .I would like to know which is best application Web or Windows to execute long running procedures in UI?

Posted 26-Dec-17 19:56pm

suresh shewale

Add a Solution

Comments

[no name] 27-Dec-17 16:37pm

If your requirement permits you can even create any windows service and invoke your stored procedure which can run in background. This service can send you notification when it start/end/error out or time to time status on mail. But also the windowds service needs to install on server where you intend to run and does not have any user interface.

suresh shewale 28-Dec-17 5:07am

thanks your suggestion but i need UI so that it can controlled by another user easily and some times it required human intervention .

[no name] 28-Dec-17 8:53am

If you need your SP to be triggered from any sort of UI you can create Forms and invoke this SP. If you have only 1 SP to be executed you may not be able to track progress and it will either only run/fail and you need to wait untill the SP complete to see the results. If you are invoking more than 1 SP in sequence you may implement logic to track current running status and see it on your UI.

vivvicks 27-Dec-17 22:52pm

Sql server jobs can help you out as they come with steps where u can add dependency of previous step.

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)