Daily SQL Query to Email

I need an asp based application that can run a simple sql query and email the results to a group of users twice daily. I need to be able to modify the delivery times and the user(s).

This will need run on a 2003 server with ISS. It should use standard Microsoft technologies.

It will not run on the SQL server.

## Deliverables

Here are some details of what you will need to do and what I have already.

***** SQL Server Info *****

Server: [url removed, login to view]\CRSSSQL (CRSSSQL is the DB Instance)

Username: readuccx password: read

Table: RtCSQsSummary

***** Query to get the data *****

Select* from [url removed, login to view]

WhereCSQName = 'MainQueue'

Results and how to display them listed below. I need to be able to have this email schedule twice per day. Once at 1200 EST and once at 2000 EST. It needs to send an email to multiple recipients.

Average Hold: convAvgWaitDuration

Longest Hold: convLongestWaitDuration

Total Calls: totalCalls

Live Handled: callsHandled/totalCalls (display as 2 digit percent)

Callback Handled: callsDequeued/totalCalls (display as 2 digit percent)

Abandoned : callsAbandoned/totalCalls (display as 2 digit percent)

***** Email would look like ****

Subject: Tickets Stats for Wed, Mar 25 ??" 12pm

Body:

Average Hold: 6:13

Longest Hold: 26:17

Inbound Calls: 235

Live Handled: 67%

Callback Handled: 15%

Abandoned : 17%

***** Script to create the identical table on your end ****

USE[db_cra]

GO

/****** Object: Table [dbo].[RtCSQsSummary] Script Date: 03/25/2010 14:53:26 ******/

SETANSI_NULLS ON

GO

SETQUOTED_IDENTIFIER ON

GO

CREATETABLE [dbo].[RtCSQsSummary](

[CSQName] [nvarchar](50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[loggedInAgents] [int] NOT NULL,

[availableAgents] [int] NOT NULL,

[unavailableAgents] [int] NOT NULL,

[totalCalls] [int] NOT NULL,

[oldestContact] [int] NOT NULL,

[callsHandled] [int] NOT NULL,

[callsAbandoned] [int] NOT NULL,

[callsDequeued] [int] NOT NULL,

[avgTalkDuration] [int] NOT NULL,

[avgWaitDuration] [int] NOT NULL,

[longestTalkDuration] [int] NOT NULL,

[longestWaitDuration] [int] NOT NULL,

[callsWaiting] [int] NOT NULL,

[endDateTime] [datetime] NOT NULL,

[workingAgents] [int] NOT NULL,

[talkingAgents] [int] NOT NULL,

[reservedAgents] [int] NOT NULL,

[startDateTime] [datetime] NOT NULL,

[convAvgTalkDuration] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[convAvgWaitDuration] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[convLongestTalkDuration] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[convLongestWaitDuration] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

[convOldestContact] [nvarchar](25) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,

CONSTRAINT [PK_RtCSQsSummary] PRIMARY KEY NONCLUSTERED

(

[CSQName] ASC

)ON [PRIMARY]

)ON [PRIMARY]

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

this will be running on a windows 2003 or 2008 server with .NET and IIS. The app will run on a different page than the SQL 2000 Server.

ASP PHP

プロジェクトID: #3292866

プロジェクトについて