Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
HomeAnnouncementsFree MagazinesWhite PapersSubmit Content
Discussion GroupsASP.NETWindows FormsLanguages.NET FrameworkVisual Studio.NET
Articles.NET FrameworkASP.NETToolsWindows Forms
.NET DirectoryOpen Source ProjectsUser GroupsWeb Resources
Related Topics
Visual Basic 6SQL ServerMS AccessOther DB ProductsMS Server ProductsMore Topics ...

.NET Forum / .NET Framework / New Users / July 2005

Tip: Looking for answers? Try searching our database.

Event Scheduler??

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Steve - 29 Jul 2005 20:01 GMT
Visual Studio 2003 / C#

I have a windows based application, with a SQL backend running on Windows
Server.  It is a basic job logging system in short.  There is a requirement
to automatically generate jobs at regular intervals.  What is the best way to
achieve this functionality. My initial thought was to create a service...but
I am not really sure what that involves, nor whether it is the right way to
go.  Can I create a Windows service, which would just call a piece of C#
code?  Then my C# code could just poll an "event" table in the database and
action any events that are scheduled for that date and time.

Any suggestions people??

Thanks

Steve
Chris - 29 Jul 2005 23:01 GMT
> Visual Studio 2003 / C#
>
[quoted text clipped - 12 lines]
>
> Steve

Yes a service would work nicely... In the service start function you
start a timer..  Then in the timer function you launch a new thread
every time you want to do work.

Chris
Steve - 31 Jul 2005 14:48 GMT
Can you provide a tiny code example of what you mean here, or explain it a
little more indepth please?  I havent done anything with threading before.

Thanks

Steve

> > Visual Studio 2003 / C#
> >
[quoted text clipped - 18 lines]
>
> Chris
notifications@csharpbox.com - 30 Jul 2005 03:44 GMT
Have you looked at SqlServer jobs? in Enteprise manager->Management.. Jobs?
This way, you will be able run stored procedures inside SqlServer... Do you
need to run this in a C# application?
Are you running SqlServer 2000? 2005?

Erick Sgarbi
www.blog.csharpbox.com

> Visual Studio 2003 / C#
>
[quoted text clipped - 13 lines]
>
> Steve
Steve - 31 Jul 2005 14:46 GMT
no I dont know what SqlServer jobs is so havent looked at that, what is it?  
I am running SqlServer 2000.

> Have you looked at SqlServer jobs? in Enteprise manager->Management.. Jobs?
> This way, you will be able run stored procedures inside SqlServer... Do you
[quoted text clipped - 21 lines]
> >
> > Steve

Rate this thread:







Free Magazines

Get these publications absolutely FREE for up to 12 months. There are no hidden fees and no obligation. Simply choose a title, complete the application form and submit it. Read more ...

Oracle MagazineNetwork ComputingComputer WorldBio-IT WorldeWeekInformation WeekInfosecurity
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.