Hello,
Can any body suggest a good solution in VB or in .Net for the following?
We need to send out mails ( 3 different mails having different schedules )
on a scheduled basis for which schedules should be maintained through our
custom intranet application.
What would be the best option? Does anybody has a readymade solution for
this whio can share with us?
Development environment are :
ASP.NET , IIS, SQL Server 2000 , C#
the options we thought are :
1 SQL server scheduled jobs. We cannot have a Mail profile in the server. In
this scenario, would this be possible? Here we loose the control as
maintanance may be difficult as it is independent of our intranet
application where the scheduling actually happning... Any suggestion?
2 Web Services .. We got a information that Web Servicess cannot run its own
but needs to have another component which consumes the Web Services Object.
Not much of idea in this case too... Any goos suggestion ?
3 Windows services : Developers here suggests against it as it could be
difficult for the maintanance. But workable. Has anybody done such kind of
Windows Programming ? can give us any idea on this?
Can anybody suggests the merits and demerits of it ?? Any other approach
could be a solution for this problem?
Any help in this regard would highly helpful for us ..
Regards
Sathian 3 1684
How about using a SQL Server job and use xp_smtp_sendmai l from www.sqldev.net?
--
Tibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/
"Sathian T" <sa*******@in.B osch.com> wrote in message news:cs******** **@ns2.fe.inter net.bosch.com.. . Hello, Can any body suggest a good solution in VB or in .Net for the following?
We need to send out mails ( 3 different mails having different schedules ) on a scheduled basis for which schedules should be maintained through our custom intranet application. What would be the best option? Does anybody has a readymade solution for this whio can share with us?
Development environment are : ASP.NET , IIS, SQL Server 2000 , C#
the options we thought are :
1 SQL server scheduled jobs. We cannot have a Mail profile in the server. In this scenario, would this be possible? Here we loose the control as maintanance may be difficult as it is independent of our intranet application where the scheduling actually happning... Any suggestion?
2 Web Services .. We got a information that Web Servicess cannot run its own but needs to have another component which consumes the Web Services Object. Not much of idea in this case too... Any goos suggestion ?
3 Windows services : Developers here suggests against it as it could be difficult for the maintanance. But workable. Has anybody done such kind of Windows Programming ? can give us any idea on this?
Can anybody suggests the merits and demerits of it ?? Any other approach could be a solution for this problem?
Any help in this regard would highly helpful for us ..
Regards
Sathian
Hi Sathian,
This is not a "ready-made solution" as you put it, however I would suggest
the following...
- Implement a GUI/HTML front-end in your intranet application which users
can use for creating scheduling records. The records are stored to a custom
table in SQL Server (normal n-tier functionality).
- Write a C#.NET Windows Service that periodically polls this custom table
in SQL Server, and sends out the emails when it finds a schedule record whose
time period is up.
- Install the service on any of your Windows servers...
NB: polling is not usually a scalable option, however it sounds like in your
case you don't have that many users?
Have a look at the following article/sample code to help you with writing a
timer-based Windows service - it's written in VB.NET (not my choice :-)
personally) but it shouldn't be too difficult to convert to C#... http://www.developerfusion.com/show/3441/1/
Hope this helps...
Patrick
"Sathian T" wrote: Hello, Can any body suggest a good solution in VB or in .Net for the following?
We need to send out mails ( 3 different mails having different schedules ) on a scheduled basis for which schedules should be maintained through our custom intranet application. What would be the best option? Does anybody has a readymade solution for this whio can share with us?
Development environment are : ASP.NET , IIS, SQL Server 2000 , C#
the options we thought are :
1 SQL server scheduled jobs. We cannot have a Mail profile in the server. In this scenario, would this be possible? Here we loose the control as maintanance may be difficult as it is independent of our intranet application where the scheduling actually happning... Any suggestion?
2 Web Services .. We got a information that Web Servicess cannot run its own but needs to have another component which consumes the Web Services Object. Not much of idea in this case too... Any goos suggestion ?
3 Windows services : Developers here suggests against it as it could be difficult for the maintanance. But workable. Has anybody done such kind of Windows Programming ? can give us any idea on this?
Can anybody suggests the merits and demerits of it ?? Any other approach could be a solution for this problem?
Any help in this regard would highly helpful for us ..
Regards
Sathian
Another option you might wish to consider is BLAT http://www.blat.net/
BLAT is a command line email tool which you could put into a batch file and
then invoke using the Windows Scheduled Task tool..
Richard Rosenheim
"Sathian T" <sa*******@in.B osch.com> wrote in message
news:cs******** **@ns2.fe.inter net.bosch.com.. . Hello, Can any body suggest a good solution in VB or in .Net for the following?
We need to send out mails ( 3 different mails having different
schedules ) on a scheduled basis for which schedules should be maintained through our custom intranet application. What would be the best option? Does anybody has a readymade solution for this whio can share with us?
Development environment are : ASP.NET , IIS, SQL Server 2000 , C#
the options we thought are :
1 SQL server scheduled jobs. We cannot have a Mail profile in the server.
In this scenario, would this be possible? Here we loose the control as maintanance may be difficult as it is independent of our intranet application where the scheduling actually happning... Any suggestion?
2 Web Services .. We got a information that Web Servicess cannot run its
own but needs to have another component which consumes the Web Services
Object. Not much of idea in this case too... Any goos suggestion ?
3 Windows services : Developers here suggests against it as it could be difficult for the maintanance. But workable. Has anybody done such kind of Windows Programming ? can give us any idea on this?
Can anybody suggests the merits and demerits of it ?? Any other approach could be a solution for this problem?
Any help in this regard would highly helpful for us ..
Regards
Sathian This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
by: A. Lovhaug |
last post by:
I have a console application built in the .NET Framework.
This application basically executes an XCopy based on
parameters that I pass to it. I use it for creating
scripts for backing up folders, etc.
All my command scripts utilizing this console application
work fine when they are executed interactively. However,
if they are executed via a scheduled task, they do not
run. Or more precisely, the script seems to execute at the...
|
by: John Bowman |
last post by:
Hi,
I have a C# app that needs to launch the "Add Scheduled Tasks" wizard found
in the control panel "Scheduled Tasks" applet. I realize that this "applet"
really just opens the tasks folder, but I need to launch the add tasks
wizard inside the folder. Does anyone have any ideas of how to do this? I
can't find anything in the MSDN regarding this. All it mentions is the Task
Scheduler API and I can't seem to find it in there either. Did...
|
by: A. Lovhaug |
last post by:
I have a console application built in the .NET Framework.
This application basically executes an XCopy based on
parameters that I pass to it. I use it for creating
scripts for backing up folders, etc.
All my command scripts utilizing this console application
work fine when they are executed interactively. However,
if they are executed via a scheduled task, they do not
run. Or more precisely, the script seems to execute at the...
|
by: satelite |
last post by:
Hello,
I am writing an exe that is intended to be run via a scheduled task.
However, I also need the flexibility to have users run the scheduled task
manually (right click task and select run). In the event a user runs the
task manually I need to verify their identity for logging purposes. So I
have two questions:
1. Is there a way to tell if a scheduled task was run because of its
scheduled time or if a user manually initiated it?...
|
by: Paulson |
last post by:
Dear Freinds
I want to make a program that acts as a reminder for the
users.I need to open up the Scheduled task wizard programmatically.If you
type Tasks in the run command the Tasks folder(ie. Scheduled Taks folder)
is opened,but what I want is to open the Add Scheduled Task wizard in it.Is
there any run command to do that?
Also if I am able to open the Scheduled Task wizard like this is
there any way by which I can...
| |
by: jinu1996 |
last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth.
The Art of Business Website Design
Your website is...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: agi2029 |
last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own....
Now, this would greatly impact the work of software developers. The idea...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
| |
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
|
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |