How To Schedule The Task To Execute Page
Sep 1, 2010
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.
View 3 Replies
Similar Messages:
Jun 2, 2010
I am trying to use schedule task on the server from the web application hosted in IIS. I have written the code to create Task and passing the valid username/password under which this task needs to run on server. But I get an error: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED)) Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.UnauthorizedAccessException: Access is denied. (Exception from HRESULT: 0x80070005 (E_ACCESSDENIED))
ASP.NET is not authorized to access the requested resource. Consider granting access rights to the resource to the ASP.NET request identity. ASP.NET has a base process identity (typically {MACHINE}ASPNET on IIS 5 or Network Service on IIS 6) that is used if the application is not impersonating. If the application is impersonating via <identity impersonate="true"/>, the identity will be the anonymous user (typically IUSR_MACHINENAME) or the authenticated request user.
To grant ASP.NET access to a file, right-click the file in Explorer, choose "Properties" and select the Security tab. Click "Add" to add the appropriate user or group. Highlight the ASP.NET account, and check the boxes for the desired access. The same code works well with console and windows service and able to create task. I understand that this is security issue. My sample app is attached at: [URL]
View 3 Replies
Sep 21, 2010
I need to schedule a task in my system with windows task scheduler and vbscript(or js also).
I want to send an http request for an aspx page in my project fom the vbscript file .This aspx page contains some database related operations.
That means when the task scheduler is started it should update my project db.
I got this link for reference
[URL]
But it is not working for me.
Can i use javascript instead of vb script?
My project is in C# and backend is sql server express 2008
View 3 Replies
May 28, 2010
How to execute asp.NET code in scheduled task of windows?
View 5 Replies
Oct 27, 2010
What are the steps to execute the task above? the reason I want to do that now is because the web site is ready for deployment and
we would like to deliver it as a DLL. I've heard of [aspnet_merge.exe] but I want to ofuscate my code with a 3rd party tool; and this ofuscator tool only works with Project-based projects.
View 6 Replies
Feb 3, 2010
How to Schedule an ASPX Page to run at a particular intervals of time using Schedule Tasks in Control Panel"? If so can any one explain me in detail "How would I achieve that with neat steps".
View 6 Replies
Jul 15, 2010
I'm trying to create a page that displays a databound gridview to the user showing them the items being processed. Then the page should immediately begin processing. The problem is that the page never shows the gridview (or any other control) until the process is complete. The process is being sent to a WCF service. I've tried setting the page to async and running the wcf in async mode but the content still fails to display.
View 1 Replies
Jun 23, 2010
I have set executionTimeout in web.config to 3600 (which I found out that the scripttimeout will follow this value), and in the production server, I have set debug=false, session time out = 20 min. sql command time out = 1200 seconds
However, when the application is performing heavy sql task that exceed 90seconds, I got the 'Page Could Not be Displayed' error.
When I change debug=true, the application works fine. The application also works fine when I turn off the 'Show HTTP friendly message'.
View 4 Replies
Feb 13, 2011
I am a bit confused about these two sequence of events or processes happening in conjunction to each other. Does the page handler executes first or does the somepage.aspx get execute first or do they happen simultaneously?
View 2 Replies
Mar 21, 2010
When a button/link is clicked, I want this URL to be called followed by the execution of the following statements. The ASP.Net page is in C# btw.
Function A
statement A
call abc.apsx
statement B
abc.aspx is a silent page, doesn't display anything on the page but creates an output.txt file. So when abc.aspx is called, output.txt file is created and Statement B is executed seamlessly.
View 3 Replies
Feb 15, 2011
I'm trying to understand how to execute AJAX animation on an asp button that has to execute code on Postback. In other words, I have button with code behind that needs to be excuted, but at the same time want to be able to have one of animation extenders be applied to it. I understand that I need to use the BeginRequest Event, I'm just not sure how, or which javascript commands to use to call the ajax animation so the postback will still occur.
View 5 Replies
Mar 10, 2011
I am looking through a sql stored procedure which I might need to update in the near future. Basically the stored procedure is about 20 lines long. The stored procedure first builds a query
and stores it in a variable named "@Sql". And then for the last two lines of the stored procedure it appears that the big sql statement stored in "@Sql" is executed by using the "EXEC" command. See below. What is confusing though is that the query appears to be exectuted twice? Why was the query written in this way. Don't both lines do the same thing? Why is it being done twice? Could this possibly be a mistake on the
part of the person who wrote the query. Below are the two lines I am talking about?
EXEC sp_executesql @sql
EXEC (@sql)
View 4 Replies
Aug 15, 2011
I am completely new to asp.net vb web programming. and am working on a web project that will require event to be trigger at user defined date and time over the web, e.g: if a user schedule an email to b sent at particular time from server. how do i go about such and where do i start from.
View 8 Replies
Feb 22, 2011
I would like to schedule a web service. In console applications, I can run them in scheduled tasks, is there a way to do it for web services?
View 3 Replies
Jan 5, 2011
how can i create a job which run a StoreProcedure in a sepcific time like 11:59pm daily and one in weekly on sat at 11:59pm and one more is that how can do backup the daily data using scheduling or job in sql server 2005
View 3 Replies
Aug 2, 2010
How can I schedule several statements that involve select ... into ..., delete, and exec one other stored proc, periodically? For instance, every 6 hours, in Sql server DB
View 1 Replies
Apr 12, 2010
I want to schedule a batch process in my APPLICATION SERVER every night by calling a stored in my database.
View 4 Replies
Aug 3, 2010
I have ASP code in asp page. I want to run the the asp code (preferable) from my asp.net page using vb.net or execute the asp page from my asp.net page using vb.net on page load_event.
View 4 Replies
Aug 19, 2010
What is the best way to call a DLL on a client PC from an ASP page?
I have asp.net page that need to call function in dll installed on client machine because this function access resources related to client. how I can do this?
View 1 Replies
Feb 2, 2011
Can i schadule my site for send email on time for example i set 8:59 and i want to automatic send email on this time.
View 6 Replies
Feb 23, 2011
I Want to Create windows schadule with my website on my host in server.
View 4 Replies
Jul 22, 2010
Schedule Hours for Using WebApp?
View 7 Replies
Aug 25, 2010
i am using .net 3.5 framework.I need to create a schedule and i need to run the schedule(daily at 12 noon) using .net.
View 3 Replies
Dec 27, 2010
I want to execute url but not to redirect to that page.My work should be cout. on the same page.. Eg :When i click on "Send" it should send that data to url bt page has to be same no effect should be their . .
View 3 Replies
Feb 11, 2011
Can I execute 2 store procedures in one asp page? I copied my code here, it doesn't give me an error but the second store procedure is not executing.
using (SqlConnection connection = new SqlConnection(ConfigurationManager.AppSettings["ConnectionString"]))
{
SqlCommand cmd = new SqlCommand("Sp_createOrder", connection);
cmd.CommandType = CommandType.StoredProcedure;
connection.Open();
//input parameters for the 1st stored procedure
cmd.Parameters.AddWithValue("@in_order_class", "WEB");
cmd.Parameters.AddWithValue("@in_owner_code", "OP");
cmd.Parameters.AddWithValue("@in_sales_campaign_code", "DEF");
cmd.Parameters.AddWithValue("@in_cus_key", null);
cmd.Parameters.AddWithValue("@in_lab_key", null);
cmd.Parameters.AddWithValue("@in_invoice_number", null);
SqlDataAdapter adapter = new SqlDataAdapter(cmd);
SqlDataReader rdr = null;
rdr = cmd.ExecuteReader();
int ChargeFine=0;
//this write the return value on the screen
while (rdr.Read())
{
Label5.Text="<strong>Order Key:</strong> ";
Label1.Text = rdr["ord_key"].ToString();
ChargeFine = Convert.ToInt32(rdr["ord_key"].ToString());
Label6.Text="<strong> Order Invoice Number:</strong>";
Label2.Text = rdr["ord_invoice_number"].ToString();
Label7.Text="<strong> Via Ship Via Code:</strong>";
Label3.Text = rdr["via_ship_via_code"].ToString();
Label8.Text=" <strong> Order Ship After Date:</strong>";
Label4.Text = rdr["ord_ship_after_date"].ToString();
}
//executing the second stored procedure
SqlCommand cmd2 = new SqlCommand("Sp_createitem", connection);
cmd2.CommandType = CommandType.StoredProcedure;
//input parameters
cmd2.Parameters.AddWithValue("@in_ord_key", ChargeFine);
cmd2.Parameters.AddWithValue("@in_long_item_number", "AC00107");
cmd2.Parameters.AddWithValue("@in_quantity_requested", 1);
cmd2.Parameters.AddWithValue("@in_price_override", null);
cmd2.Parameters.AddWithValue("@in_shipment_type", null);
cmd2.Parameters.AddWithValue("@in_size", null);
cmd2.Parameters.AddWithValue("@in_color", null);
cmd2.Parameters.AddWithValue("@in_subscription_issues", null);
cmd2.Parameters.AddWithValue("@in_sub_start_date", "");
cmd2.Parameters.AddWithValue("@in_sub_to_renew", "");
cmd2.Parameters.AddWithValue("@in_lab_key", "");
cmd2.Parameters.AddWithValue("@in_ship_via", "");
cmd2.Parameters.AddWithValue("@in_ship_after_date", "");
cmd2.Parameters.AddWithValue("@in_edi_sku_ID", "");
cmd2.Parameters.AddWithValue("@in_edi_style_ID", "");
cmd2.Parameters.AddWithValue("@in_edi_size_ID", "");
cmd2.Parameters.AddWithValue("@in_edi_color_ID", "");
cmd2.Parameters.AddWithValue("@in_check_item_for_duplicates", "");
connection.Close();
View 2 Replies
