April 8, 2009 at 1:36 pm
I have developed a series of queries - about 80 in all which takes about 3 to 4 hours to run,when I run them in succession. I would like to automate them to run all together and/or maybe create a front end for a person to run them; as if it were an application, my only desire would be to keep the code as private as possible, can anyone suggest a way for me to allow someone else the run the queries and provide a front end, yet preserve my work so that is is not copied?
My only programming platform is ASP.
Thanks for any suggestions
April 8, 2009 at 2:31 pm
Are they something that needs to be run by a user, or would a scheduled job be a better option?
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
April 8, 2009 at 2:52 pm
I would *like* to give certain feedbacks to the person - (although it could probably all be automatic) like:
first query is more of a BCP import --> I would like to tell the person "imported 3,876,98 records" then maybe tell them each step..... "now counting duplicate records"
Although this would all be secondary to preserving the query code ( don't want to sound selfish but this took a couple of years to develop the right queries )
The truth is, it could all be completely automatic - with very simple feedback ( like "job done") - it takes about 3 hours to run - not sure if an ASP page could stay open that long or if that even makes sense... I wouldn't be afraid of trying somethng in Visual Basic if it was recomended.
April 8, 2009 at 3:16 pm
Hi kevin
I think the main problem will be the duration of your queries in combination with a web front-end due to the server timeout.
The only way would be a AJAX approach. You start the queries from your web page request feedback every some seconds.
I also never saw a web application a user wants to sit three hours in front of it. You should create a gorgeous progress bar :hehe:
I would suggest GSquareds approach with a job. The user connects to the web page and hits a button which creates a job and starts it. When everything is done (s)he gets an email.
Greets
Flo
April 8, 2009 at 3:22 pm
Yes Flo,
That makes sense, I was definitely having issues with the amount of time it would take and see that a web page is probably not the way to go - so you are saying "create a job" - is that different then firing off an initial query? Is there any way to preserve/hide code this way?
April 8, 2009 at 3:27 pm
Create stored procedures containing your queries and use the ENCRYPT option so they will no be available for anybody at the server. Now create a job which just executes the procedure(s).
Greets
Flo
April 8, 2009 at 4:10 pm
Thank You
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply