SQL generated html email notifications for external customer orders.

Đã hoàn thành Đã đăng vào Sep 5, 2014 Thanh toán khi bàn giao
Đã hoàn thành Thanh toán khi bàn giao

• Create a separate Database with individual Tables for each program, with SQL jobs running every *mins to recreate Tables

• Email Program/script is linked to Data in Tables

• Email Program/script runs every *mins and gathers recent data from tables, formats into HTML and sends email.

o Respond button is configured to update DB information re email addresses

o Separate Mailbox configured for this response (internally handled)

o CST to maintain mailbox (internally handled)

o Email format and wording customisable by internal IT once complete

We have the view's created, could be optimised and also have draft email wording.

Xử lý email Microsoft SQL Server SQL

ID dự án: #6415227

Về dự án

4 đề xuất Dự án từ xa Sep 5, 2014 đang mở

Được trao cho:

feninsoftech

Hi, This can be achieved by designing a SQL Server Stored Procedure. Procedure will be configured as SQL Job. Email will be send using xp_senddbmail. I have 8.5 years experience in SQL Server 2005|2008|2008R2|201 Thêm

$277 AUD trong 17 ngày
(27 Đánh Giá)
5.9

4 freelancer chào giá trung bình$260 cho công việc này

yugolancer

For each program, means how many programs in total? oRespond button will update DB info reading addresses from what/where? Thank you

$236 AUD trong 3 ngày
(17 Nhận xét)
6.2
rinsadsl

Hi Good Day I can handle your project. Please have a look at my past projects. Done pretty well with PHP and MySQL. I need a couple of points clarified from you. Looking forward to hear from you. Thanks Rinsad

$263 AUD trong 7 ngày
(29 Nhận xét)
5.3