473,322 Members | 1,259 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,322 software developers and data experts.

How to schedule the task to execute ASP page

I am creating a feature which will allow users to import data of excel sheet to database.

First, data will be imported from excel sheet and will be displayed in a tabular format.

User performs a mapping porcess for database fields and click Submit button.

Then a stored procedure inserts all the data of each row into more than 15 tables.

Above mentioned process might cause an issue if users import more than 1000 records (they are definitely going to do that. Thats why this entire functionality is intended for).

Basically, what I would like to do is, Insert all the rows to a single table (Temp table), have a cloumn in a table which will be a flag and initially, will be set to "Pending".

Create a page which will be executed when there are less users accessing the system (Specific time),

This page will see if there are records in a temp table with FLAG "Pending". If yes then it will fetch one record from the table and will insert data of first row into all the necessary tables. After first transaction it will wait for some time and will fetch the second record....This will last until the final row of temp table is reached.

Now, my main concern is that, HOW CAN I SET A TIMER FOR ASP, ASPX PAGE TO EXECUTE IT AT A SPECIFIC TIME PERIOD.

Thanks....!
Sep 1 '10 #1
3 2215
wizardry
201 100+
actually a procedure would be better to handle this type of transaction on your server. so i'll assume your using sql server 2k or windows server; since your using asp.net.

the first thing i would do is:
1. apply date/time stamp to the inserts on the temp table.
2. you could create a function say activity and the call activity from the procedure insert_temp.

function activity will query all connections. then you can set a value for it to execute when connections is less then 10 users.

you can query connections from the $v_System in oracle or system in sql server. and see who is on and what type of connection. just familiarize your self with those tables.

then have your proc do your executing.

it's less overhead in theory. or you could put your proc on an asp page like you want and see your over head. but to do what you want to do which is data processing. its best to be used from the database, assigned cache, memory, threading, etc...
Sep 1 '10 #2
I like your solution, but I have some questions...
Applying date/time stamp means having a column to insert a date in temp table?
If yes, how can I make a use of it.

How can I execute a function automatically/frequently?
Sep 2 '10 #3
wizardry
201 100+
yes have a column insert date/time. you can use this field to set your procedure to run i.e. qry = select date, from tmp where date <= now() || date = '09/01/2010' so that you can run whats considered a batch job.

because that is your ultimate result is batching the data.

you can also use that for auditing purpose so that you can create a very precise workflow chart when it might be time to do tunning. say for instance one week you have a million records 3 days that week. so that means a total of 3 million records are going to be needed batched. when its low over head ( less users ) .

you can execute this by using transctions. or set it in the scheduler to run a batch.dat which calls your database to log in. so you create a user to access just that proc. then the system will handle the rest because your batch user call the proc() and the proc should execute fine on the other tables. if not then you could add a connect user() clause in the proc so that it executes fine.
Sep 2 '10 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: Mullin Yu | last post by:
How can I do so? Can I write a windows service that will run a bat file when the system shuts down? I want to write a service because I can create a schedule task by Windows Scheduler only when...
1
by: krallabandi | last post by:
Hi, I have a console application written in VB.NET. I schedule the job using windows 2000 scheduler. It is all working fine but, its opening a console when it was running. How to disable the...
6
by: nilesh soni | last post by:
HELLO EVERY ONE ! I HAVE TO SCHEDULED A TASK TO RUN EVERY DAY AT 4PM, TO CHECK THE SIZE OF THE NOTIFICATION LOG FILE , IF IT EXCEEDS 5MB, THEN I NEED TO RENAME THE FILE AND START WITH A NEW ONE...
1
by: Dean Slindee | last post by:
I am writing a VB.Net application that will replace a series of DTS packages. The DTS packages run once a day at a scheduled time automatically. Would this new application be a Windows Service...
1
by: Alan T | last post by:
I have created a scheduled task successfully programmaticall. However, there is something wrong in the process. When the scheduled task is running and stopped, the result was: "0xe0434f4d". I...
2
by: =?Utf-8?B?TWlrZQ==?= | last post by:
Hi. How can I schedule an ASPX page to execute every hour? I know this request is odd & there are plenty of better ways to accomplish running an automated task every hour. That being said, is it...
1
by: cvbayot | last post by:
i'm doing a web based application that has a feature of sending sms messages. the process: when a costumer send a text message to the system, the system will send the same message to the assigned...
0
by: Shina35 | last post by:
Hi All, i scheduled a windows task that is running VBS file that run QTP. the script is running once at the time i set and the day after at the same time it's not running although i set it to run...
2
NeoPa
by: NeoPa | last post by:
My server is running Windows 2000 (All latest SPs & updates) and I need to start a job in the early hours with a specific network account and in interactive mode. I have been using the AT command...
6
by: jumbojs | last post by:
I want to call a method in a web page that I want to call every hour on my web application and run the code. I have now Idea of how to do this. Any help would be appreciated. Thanks
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
by: Faith0G | last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
0
isladogs
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 using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.