|
|
Posted by David Portas on 08/23/06 12:26
teddysnips@hotmail.com wrote:
> ACCESS FRONT END
> SQL SERVER BACK END
>
> My client wants me to implement a system to allow e-mails to be sent to
> their customers on a timed basis. For example:
>
> Day: Monday
> Start 00:30
> Interval 30 mins
>
> Day: Sunday
> Start 00:30
> Interval 60 mins
>
> In the past I've successfully implemented an e-mail notification that
> runs once a day as a scheduled job.
>
> My first thought for this new system would be to have seven different
> jobs, one for each day of the week, to reflect different start times
> and interval settings.
>
> However the client, who has a little knowledge of these things, seems
> to want something that will run more like a Windows Service, using some
> sort of configuration file or database table to determine the day, and
> therefore the start time and interval for the job. This will, of
> course, have the benefit of only changing configuration parameters in
> one place, rather than having to open and edit seven jobs. In
> addition, if this were done from a table, one could provide an
> interface to allow non-technical users to make changes.
>
> Anyone any thoughts? I realise I've been somewhat vague - I don't have
> any problems with the internals of formatting and sending the e-mails,
> only the best way to schedule it.
>
> Thanks
>
> Edward
Take a look at Notification Services:
http://www.microsoft.com/sql/technologies/notification/default.mspx
--
David Portas, SQL Server MVP
Whenever possible please post enough code to reproduce your problem.
Including CREATE TABLE and INSERT statements usually helps.
State what version of SQL Server you are using and specify the content
of any error messages.
SQL Server Books Online:
http://msdn2.microsoft.com/library/ms130214(en-US,SQL.90).aspx
--
Navigation:
[Reply to this message]
|