I'm part of a team that has been given a project that I'm a little lost on,
so I'm looking for input on how this could be accomplished. We don't have
much time to fully develop this, so it has to be as simple as possible
Let's say we have 5 - 10 existing stored procedures (that can't be changed)
that are run manually, once a month
We are tasked to build a web interface, which will list each item (sproc),
and include a label showing the progress (running, error, finished) --
All except the current item will be disabled (this I know how to do easily
enough, so don't worry about that)
The problem is - if I click on a button and the code kicks off to run the
item's stored procedure, what are the possibilities available to 'poll' the
method that was run, to see if it received an error or if it's still
running, or if it's finished?
Ideas? 2 1526
I would create an SQL jobs out of them and then use SQL to start job or
check status
See sp_help_jobhistory, sp_start_job
George.
"Elmo Watson" <ew@whereveryouare.comwrote in message
news:uC*************@TK2MSFTNGP04.phx.gbl...
I'm part of a team that has been given a project that I'm a little lost
on, so I'm looking for input on how this could be accomplished. We don't
have much time to fully develop this, so it has to be as simple as
possible
Let's say we have 5 - 10 existing stored procedures (that can't be
changed) that are run manually, once a month
We are tasked to build a web interface, which will list each item
(sproc), and include a label showing the progress (running, error,
finished) --
All except the current item will be disabled (this I know how to do easily
enough, so don't worry about that)
The problem is - if I click on a button and the code kicks off to run the
item's stored procedure, what are the possibilities available to 'poll'
the method that was run, to see if it received an error or if it's still
running, or if it's finished?
Ideas?
How can I use that to help update the web page?
"George Ter-Saakov" <gt****@cardone.comwrote in message
news:Og**************@TK2MSFTNGP05.phx.gbl...
>I would create an SQL jobs out of them and then use SQL to start job or check status
See sp_help_jobhistory, sp_start_job
George.
"Elmo Watson" <ew@whereveryouare.comwrote in message
news:uC*************@TK2MSFTNGP04.phx.gbl...
>I'm part of a team that has been given a project that I'm a little lost on, so I'm looking for input on how this could be accomplished. We don't have much time to fully develop this, so it has to be as simple as possible
Let's say we have 5 - 10 existing stored procedures (that can't be changed) that are run manually, once a month
We are tasked to build a web interface, which will list each item (sproc), and include a label showing the progress (running, error, finished) -- All except the current item will be disabled (this I know how to do easily enough, so don't worry about that)
The problem is - if I click on a button and the code kicks off to run the item's stored procedure, what are the possibilities available to 'poll' the method that was run, to see if it received an error or if it's still running, or if it's finished?
Ideas? This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: noah |
last post by:
Does PHP have a feature to associate Cookie sessions with a persistent
database connection that will allow a single transaction across
multiple HTTP requests?
Here is how I imagine my process: I...
|
by: pb648174 |
last post by:
I have a table called BidItem which has another table called
BidAddendum related to it by foreign key. I have another table called
BidFolder which is related to both BidItem and BidAddendum, based...
|
by: Stanley Sinclair |
last post by:
I have a need to return multiple result sets from a stored procedure.
Want that SP to call others to get the data.
Win2003, db2 8.1.5.
Can't figure out how to handle open cursors, and return...
|
by: Steve Jorgensen |
last post by:
I've run across this issue several times of late, and I've never come up with
a satisfactory answer to the best way to handle this schema issue. You have a
large section of schema in which a...
|
by: James Radke |
last post by:
Hello,
I have a multithreaded windows NT service application (vb.net 2003) that I
am working on (my first one), which reads a message queue and creates
multiple threads to perform the processing...
|
by: TC |
last post by:
I need to design a system which represents multiple "projects" in SQL
Server. Each project has the same data model, but is independent of all
others. My inclination is to use one database to store...
|
by: nishi57 |
last post by:
I hope I can get some help regarding this issue, which has been going
on for a while. I have a desktop user who is having problem running
"Stored Procedures". The DB2 Connect application works fine...
|
by: Otto Carl Marte |
last post by:
Hi,
As I understand it, Declared Global Temporary Tables (DGTTs) have a
scope that is session/connection based.
Using the same connection, I have discovered that if I declare a DGTT
in one...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: aa123db |
last post by:
Variable and constants
Use var or let for variables and const fror constants.
Var foo ='bar';
Let foo ='bar';const baz ='bar';
Functions
function $name$ ($parameters$) {
}
...
|
by: ryjfgjl |
last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Sonnysonu |
last post by:
This is the data of csv file
1 2 3
1 2 3
1 2 3
1 2 3
2 3
2 3
3
the lengths should be different i have to store the data by column-wise with in the specific length.
suppose the i have to...
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
| |