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 RepliesI Want to Create windows schadule with my website on my host in server.
View 4 RepliesI have the following database, consisting of 3 tables: Job, JobPhase, Assigned (as seen in the following image)
[URL=http://img836.imageshack.us/i/87157705.jpg/][IMG]http://img836.imageshack.us/img836/8710/87157705.th.jpg[/IMG][/URL]
I'm trying to create a page that will hold a table. The table will represent, for a particular employee (ID = D_ID), his/her corresponding Job Schedule sheet.
I'm new to asp.net c#2 ddlist : mean that choose from ddlbeginwk to ddlnextwk and a button btnlookupin my DB is ms sql express and i have 2 main table:
Teach_Week_id int
Name_Week nvarchar
Term int --there a 2 term per year in my school
[code]...
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 RepliesComing to my task, I have to schedule a process which will delete all the files in the paticular table with particular key.I have the stored procedure for the deletion. What all I need is, How to schedule this process in the application server.?
View 5 RepliesI 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 RepliesI 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 RepliesI want to schedule a batch process in my APPLICATION SERVER every night by calling a stored in my database.
View 4 RepliesI 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.
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 RepliesSchedule Hours for Using WebApp?
View 7 Repliesi 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 RepliesI don't want to use SSRS web service to schedule SSRS report rather than wants to use sharepoint jobs to schedule SSRS report. Let me know possibilty.
Technology
- SQL Server 2008 R2
- SharePoint 2010
Well, I'm sure this is not the first time to see this question. and TBH you can find this question answered on many other websites and blogs -not only here-
But I never saw a complete answer for this question, I mean no one talked about the advantages and the disadvantages. no one shared a real experience.
Although Quartz.NET seems like a good solution but yet, there's no enough reviews or a good comparison between the different ways to achieve such a thing.
As far as I read about it I found this are the possible ways of doing this :
Using a: Web Service, Windows Appliction, Console Application, Quartz.NET.
Examples of stuff I want to achieve with the scheduled or automatic methods/events are like archiving after a certain period, auto deleting/moving records in the database, setting a property of an object after a certain time, automatically run some methods according to my holiday schedule.
I hope you'd share your experience either with one of those approaches or share a new way of doing this.
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]
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
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 RepliesI can able to post now FB comment post from asp.net system but if i want to schedule some message from my sytem what can i do ? How can i store FB account ?
View 1 Repliesi have a time and at 12:00,14:00 and 16:00 i need a email to go out daily, but i been trying to code how to set time with no luck .... i also google it as well
View 1 RepliesI i want to schedule an asp.net page on my hosting, how to achieve it?
for instance, i have a page named myservice.aspx runing on my website.com/myservice.aspx
i want to run this page on every 24 hours.
I want to know how to create events calendar in asp.net , monthly view, weekly view, day view.... any article link to refer..
View 1 Repliesi want to take sql table .sql extesion in sql server 2008r2
View 1 RepliesHOWTO create ASP.NET C# controls on server side for posted data that had no runat=server on the client.
I have processes needing to post files to a ASP.NET application. These processes must post without runat=server as such:
<form ~~~~ to some ASP.NET/C#/aspx page>
<input type=file name=MY_FILE ~~~>
</form>
On the ASP.NET page, in the Page_Load I would code somethign like this:
[URL]
Here is the trick, the control "fileLIST_FILE" does not exist because the HTML does not have runat=server on it.
If the client did have runat=server the designer.cs would have somethign liek this:
System.Web.UI.HtmlControls.HtmlInputFile fileLIST_FILE;
With all that said, I want to make "fileLIST_FILE" on the fly inside Page_Load fromt he posted name of "MY_FILE".
do not focus on the fact that this is a file upload. I would like to know how to do this for any posted FORM data.
I have a mdf database in my computer. And I have sql management studio 2005 installed. I would like to mange the mdf database with this program and I do not know how.
View 3 Replies