Automatic Updates?

[James Thomas]

Hello -

I have a web application done in ASP .NET and SQL Server that tracks
certain things for users. Currently, they must log on to be notified
when the items they have stored are getting ready to expire.

Some have asked if they could be sent emails such that they are
automatically notified via email when their information is getting
ready to expire.

Can anyone point me in the right direction (don't need code, just
thoughts on where to start) so I can provide this functionality?

Thanks,

James Thomas

[Curt_C [MVP]]

You wont do it with ASP.NET. By that I mean you want a process to run/check
all the time. You are trying to use a call/retrieve system without a
call.....

--
Curt Christianson
Owner/Lead Developer, DF-Software
Site: http://www.Darkfalz.com
Blog: http://blog.Darkfalz.com
"James Thomas" <Ra****@nospam.nospam> wrote in message
news:10*************@corp.supernews.com...

Hello -

I have a web application done in ASP .NET and SQL Server that tracks
certain things for users. Currently, they must log on to be notified
when the items they have stored are getting ready to expire.

Some have asked if they could be sent emails such that they are
automatically notified via email when their information is getting
ready to expire.

Can anyone point me in the right direction (don't need code, just
thoughts on where to start) so I can provide this functionality?

Thanks,

James Thomas

[James Thomas]

Fair enough. I was hoping I could use ASP .NET but didn't think I
could. Never hurts to be hopeful. :)

That said, what system should I use then?

Curt_C [MVP] wrote:

You wont do it with ASP.NET. By that I mean you want a process to
run/check all the time. You are trying to use a call/retrieve system
without a call.....

[nicolobj]

You can create an executable file and create a scheduled
task in Windows Scheduler that runs the program when you
need it to if you have admin rights to the server you ar
hosting the site on.

-----Original Message-----
Hello -

I have a web application done in ASP .NET and SQL Server that trackscertain things for users. Currently, they must log on to be notifiedwhen the items they have stored are getting ready to expire.
Some have asked if they could be sent emails such that they areautomatically notified via email when their information is gettingready to expire.

Can anyone point me in the right direction (don't need code, justthoughts on where to start) so I can provide this functionality?
Thanks,

James Thomas
.

[James Thomas]

Thanks! This is what I will do. Appreciate the suggestion.

nicolobj wrote:

You can create an executable file and create a scheduled
task in Windows Scheduler that runs the program when you
need it to if you have admin rights to the server you ar
hosting the site on.

-----Original Message-----
Hello -

I have a web application done in ASP .NET and SQL Server

that tracks

certain things for users. Currently, they must log on to

be notified

when the items they have stored are getting ready to

expire.

Some have asked if they could be sent emails such that

they are

automatically notified via email when their information

is getting

ready to expire.

Can anyone point me in the right direction (don't need

code, just

thoughts on where to start) so I can provide this

functionality?

Thanks,

James Thomas
.

[Steven Cheng[MSFT]]

Hi James,

If you're wanting to do it in ASP.NET, I'm afraid we haven't good means but
to constantly query the db to detect it. But what's your server's OS
version( where the SQL server running on). Based on my experience, such
task can be done by the SQLServer's Notification Service which can help
send notification actively to other application or end users . But seems
the Notification service has some limitation on certain windows systems.
Anyway, you can have a look at the following reference:

#SQL Server Notification Services Books Online
http://msdn.microsoft.com/library/en...started_4mn9.a
sp?frame=true

Hope also helps.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[James Thomas]

THanks for the reply. I have implemented this using a suggestion
nicolobj left wherein I created a .NET Windows application that I set
Task Scheduler to run once a week. Works like a charm.

Thanks!

James

Steven Cheng[MSFT] wrote:

Hi James,

If you're wanting to do it in ASP.NET, I'm afraid we haven't good
means but to constantly query the db to detect it. But what's your
server's OS version( where the SQL server running on). Based on my
experience, such task can be done by the SQLServer's Notification
Service which can help send notification actively to other
application or end users . But seems the Notification service has
some limitation on certain windows systems. Anyway, you can have a
look at the following reference:

#SQL Server Notification Services Books Online
http://msdn.microsoft.com/library/en...ettingstarted_
4mn9.a sp?frame=true

Hope also helps.

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)

[Steven Cheng[MSFT]]

Thanks for your followup James,

Happy Holidays!

Regards,

Steven Cheng
Microsoft Online Support

Get Secure! www.microsoft.com/security
(This posting is provided "AS IS", with no warranties, and confers no
rights.)