Courtney,

Just a thought (I'm assuming you are using SQL Server): you could actually
leverage the SQL Server Agent to do what you describe.  That way you
wouldn't even need your own service.  All you would need to do is to create
a Job under the SQL Server Agent and specify the times that you want it to
launch.  Then add steps to the job that call the stored procedures and send
emails etc.  This would all be written in T-SQL.

Anyway, if this sounds interesting, let me know and I can give you more
detail if you want.

Russ

At 05:39 AM 7/30/2003 -0700, you wrote:
Hello,

I'm taking a stab at windows services for the first
time.  My windows service is written in vb.net (not my
lang of choice but I have to go with the flow of the
department).  It is running a once a day timer that
calls several stored procs and depending on the size
of the returned values(s) sends out emails.

Now for my questions.  Can I expect Windows Services
in .Net to have a considerable memory foot print?  I
check and rechecked the closure of my only dataset and
datareader objects.  I have also set them to nothing
when I have finished using them.  This service is only
called once a day.  When it first started it uses a
woping 7MB of RAM...then on first execution it uses
18MB and this stays constant execution after
execution.

I monitored the size hoping the garbage collector
might help me out but to noavail.  I do not implement
IDispose if that helps.

thanks in advance for any advice!

Courtney

=====
Courtney Smith
[EMAIL PROTECTED]

Reply via email to