|
Hi
We are using Visual Studio 2005, C# and SQL Server 2005. We are developing a system that is a combination of some Windows Application modules and a Web application (intranet). We have a number of maintenance processes that we would like to schedule to run automatically a few times a day. What is good way of handling scheduling in this type of scenario?
Second questions is whether we could create Web Services to handle these maintenance processes and schedule the system to consume the web services at regular intervals.
Any advice will be appreciated.
Thanks
Kobus
|
|
|
|
|
Your second question answers for the first. That is a good method of creating webservice to handle schedule process. You need to create a windows application too, which request to the webservice frequently.
|
|
|
|
|
For First Question:
Yes we can execute maintenance processes that we would like to schedule to run automatically a few times a day. in sql server by providing a mechanism
SQL SERVER INTEGRATED SERVICE(DTS).
On which you do every code script on the FLY.
Thanks & Regards
Tarini Singh
Sr. Software Engineer. (IT)
tksingh@zentagroup.com
|
|
|
|
|
For First Question:
Yes we can execute maintenance processes that we would like to schedule to run automatically a few times a day. in sql server by providing a mechanism
SQL SERVER INTEGRATED SERVICE(DTS).
On which you do every code script on the FLY.
Thanks & Regards
Tarini Singh
Sr. Software Engineer. (IT)
tksingh@zentagroup.com
|
|
|
|
|
Start|Programs|Accessories|System Tools|Scheduled Tasks
|
|
|
|
|
Hello there,
I have a bunch of tables that must be created in oracle while installing my c# application, any idea how to make that happen?? currently I'm saving my tables ddl statements in a .sql file.
Many thanks
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
Can you execute a query against an Oracle database from C# code? I guess you must be doing it in you app. Can't you execute the CREATE TABLE statements the same way?
|
|
|
|
|
Thank you chopeen
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
1. I had to put my DDL statements in a text document.
2. Make sure your statements are followed by /
3. Save it to YourScriptFile.sql
4. Create a batch file in which you are calling sqlplus YourScriptFile.sql
5. In your windows form, call that batch file using a process.
Smile: A curve that can set a lot of things straight!
(\ /)
(O.o)
(><)
|
|
|
|
|
Hi
I need to create a temporary unique id on a offline computer.
The item will get a unique id (in our server, not worldwide!) when it connects to the server. But how do i ensure that a temporary id is unique until i get access to the server?
The only decent solution i have come up with is to use DateTime.Now.Ticks. But that could go fubar if the clock is changed.
Is that another better way to do it?
The id doesn't have to be globaly unique, just unique for the active computer.
"Life would be alot easier if i only had the sourcecode!"
|
|
|
|
|
Why don't you use Guid.NewGuid() ?
I know you don't really need GUID, but it won't hurt, will it?
|
|
|
|
|
Use a Guid. It is designed for this purpose. Sure it is globally unique, but creating an ID that is only locally unique is more complex so why bother.
|
|
|
|
|
Thanks for the help!
A guid is abit long but as you say it's to much of a bother to come up with another solution
|
|
|
|
|
Hi friends
I wrote a program that create a thread to listen a port in network. but in my thread I can't change my windows form element like lable. What is the problem?
|
|
|
|
|
Hello,
If you want to change the GUI from an other thread, you have to use Invoke[^] and InvokeRequired[^]!
All the best,
Martin
|
|
|
|
|
The problem is that form elements can only be manipulated from the thread that is running the UI. There is a method called Invoke on the form that you must use to do this from another thread. The docs for this method contain a reasonable example.
|
|
|
|
|
Another way to avoid using invoking and delegates...is to set the
CheckForIllegalCrossThreadCalls property to false, although it's better to use invoking
Do your best to be the best
|
|
|
|
|
i m developing web application in which i m sending and receiving sms through mobile connected with a cable. but sms is not receiving.
|
|
|
|
|
You asked the same question 2 hours ago and on neither occasion have you provided anything like enough information to give you any help.
|
|
|
|
|
How do I write a statement that calls the Focus method of a control named txtLastName using C#
|
|
|
|
|
txtLastName.Focus();
Becoming Programmer...
|
|
|
|
|
Either buy a book, or stop trolling.
Christian Graus - Microsoft MVP - C++
"I am working on a project that will convert a FORTRAN code to corresponding C++ code.I am not aware of FORTRAN syntax" ( spotted in the C++/CLI forum )
|
|
|
|
|
The process of creating an instance of a class is called?
|
|
|
|
|
Instantiation?
Paul Marfleet
|
|
|
|
|
this is very rubbish do send some what acceptable questions...:->
|
|
|
|