Emailing From MS SQL

Mar 14, 2004

Hey,

I would like to set up a job to send mail out to clients on a semi-regular basis. Is there a way to mail directly from MS SQL.

or some application which I can set to interface with MS SQL and send these mails out.

I'm currently using asp.net, however, doing it through the web is very time consuming, I would much rather use some application to generate the mails on the server as it currently takes close to 20 min to send through the web interface (and that's only to 900 members, we are looking at having at least 2000 members in a few weeks). What am I looking for is something I can call perhaps with transact sql so I can run it through an ms sql server job, however any solution you have would be fantastic.

If you don't have specific details, that's fine, I'm not even sure what apps etc to look into, even a name of some technology to use (or does MS SQL have a way of doing all of this itself?)

Thanks a lot for your help, life saver ;-)

View 8 Replies


ADVERTISEMENT

Emailing The Outputs

Apr 13, 2000

I need to send the output of a report generated, automatically through email as an attachment to some customer.Is it possible?Can anyone help?

View 1 Replies View Related

Emailing From SQL Server

Dec 8, 2004

Hi everyone,

I am running SQL Server Enterprise Manager and i would like to have a query run everynite and send the results returned by the query off to an email address....

How can i do this?

View 3 Replies View Related

Emailing Reports

Nov 5, 2004

Hi everyone I have a database that I am creating for another department. He emails applications to potential vendors. And I was wanting sql to do this for him. I was reading about xtended procedures XP_Sendmail, but this is the first time I have created an extended stored procedure. I need for it to email an attachment (the report)

View 1 Replies View Related

Emailing An Attachment From DTS

Feb 7, 2006

I have a DTS package that runs 4x a day and generates an excel spreadsheet, renames that spreadsheet with a datetime stamp and then places it into a folder on our network. I have been asked to email that spreadsheet to someone everytime the package runs.

My question is what would be the best way to handle this and how do I ensure that whatever process I define grabs the correct file? The folder that the Excel file is being placed into has multiple files in it. Is there a way to tell SQL Server which file to grab and email?

Any thoughts or suggestions would be greatly appreciated! Thanks!



Frank

View 1 Replies View Related

Emailing Errors

Feb 19, 2007

I'm sort of new to SSIS so I apologize if this is a trivial question:

I setup a package and want it to email me if there is any errors. Right now I got it working to send me a pre-written message about the failure, but I want to load the full task failure message into variable and email it on the email body.

But so far I have not found a way to save the error messages into variables so I can email them. Anyone can help with that one?

View 4 Replies View Related

Emailing Report

Apr 5, 2007

I need to export a view into excel and mail to my manager daily morning. Is there a way i can automate this process. I know how to convert view to excel but i need a better solution to automate this process with emailing to my mgr. Please suggest a better approach of doing this.



Thanks,

View 5 Replies View Related

Emailing From Stored Procedure

Jan 5, 2001

Whenever a certain stored procedure executes I need to email both admin and clients (different messages). I have created an error within the SP and can RAISE the error and thus notify admin staff but how can i email the client also ? I can obtain the cient email address from thye system but how can i email them ? Can i use xp_sendmail within a stored procedure ? If so, how as i can't seem to get it working ?

thanks for help

View 1 Replies View Related

Auto Emailing From With In SQL2000

Oct 20, 2002

Hi there!
Is there a way, I can setup create a script that I can schedule, which runs through my user databases and if e.g.:
1:) there is less than 20% free space it emails me.
and/or
2:) there is less than 200MB free space
it emails me.

Cheers
Henrik Hansen

View 6 Replies View Related

Emailing Query Results

Oct 21, 2004

Is there a way to have SQL server email the results of a Select query to someone?

View 1 Replies View Related

Emailing After A Record Has Been Added

Jan 8, 2008

Hi,
Is there a built in capability with sql server 2005 which sends emails to users upon a record insertion.
Thanks

View 2 Replies View Related

Emailing An Excel File

Aug 31, 2007



Hi ,


Is it possible for us to send an excel file generated in the package to the users using Sendmail task or anyother task using SSIS?

Any help is greatly appreciated.

Thanks,
SVGP.

View 5 Replies View Related

Checking Data And Emailing The Results....

Jun 28, 2006

Hello,
 
I am trying to use €œSQL Server Business Intelligence Development Studio€? (what is the short name for this) to complete a check and then possibly email me depending on what happens.
 
The check is around two tables that I have. There is a chance that they will become out of sync with each other and so I want to know when a field (ACCOUNTID) has a value that is in one table and not the other. I can do the check but I would like the package to email me when there is a problem (and if possible email me the details) and do nothing when everything is OK.
 
Can anybody give me some hints to point me in the correct direction as I just seem to be chasing my tail at the moment,
 
Thanks,

View 5 Replies View Related

Emailing Long Messages From SQL2000

Oct 26, 2006

Hello!
The problem is this.

I have many short messages in a table. I need to tigh them together in one long email message and email to the users.
But xp_sendmail is limited to 7,790.
How could I send longer messages? Or how could I devide the long message and send it in parts (i.e. separate consequtive emails)?

This doesn't work, it still cuts the messages off at around 7,790:
E. Send messages longer than 7,990 characters

This example shows how to send a message longer than 7,990 characters. Because message is limited to the length of a varchar (less row overhead, as are all stored procedure parameters), this example writes the long message into a global temporary table consisting of a single text column. The contents of this temporary table are then sent in mail using the @query parameter. CREATE TABLE ##texttab (c1 text)
INSERT ##texttab values ('Put your long message here.')
DECLARE @cmd varchar(56)
SET @cmd = 'SELECT c1 FROM ##texttab'
EXEC master.dbo.xp_sendmail 'robertk',
@query = @cmd, @no_header= 'TRUE'
DROP TABLE ##texttab

View 7 Replies View Related

Continuation Of Emailing An Excel File

Sep 12, 2007

Hi Rafael,

I need to create a new excel file daily and then need to mail it.
The problem iam facing is that ,when i schedule a job the task that dumps data into excel(Dataflow task ) gives a validation error.Everytime i need to manually link the sheets of the excel to the corresponding tables.
Any idea why this is happening?So iam unable to schedule as a job...

Thanks,
Vani.

View 3 Replies View Related

Automatically Running Reports Then Emailing Out

Feb 4, 2008



Hi All

I'm hoping someone here will be able to guide me in the right direction. I am trying to figure out a way of looping through table columns or a flat file in which there will be three parameters every time. With these parameters I am then wanting to run a report using two of these parameters to feed into the report and then email this out to an email address which would be my third parameter. Does anyone here have any idea how I would go about doing this?

Many thanks in advance.

View 5 Replies View Related

SQL 2012 :: Scheduling And Emailing Custom Reports?

Jun 19, 2014

I have downloaded MS's performance dashboard report and installed. I wanted these report should automatically send the performance report to my email.

View 1 Replies View Related

SQL Server 2008 :: Custom Alert Is Not Emailing Operator?

Apr 8, 2015

I am trying to create an alert when there are more than 2500 connections to our ailing SQL Server.However, for now, I need to restart the SQL server service because users begin complaining they can't connect.

1) I created an operator - me.

2) I created a job which runs a query.

INSERT INTO Sessions_alert
SELECT host_name, program_name, login_name, count(c.session_id ) num_sessions, getdate()
FROM sys.dm_exec_connections c JOIN sys.dm_exec_sessions s on c.session_id = s.session_id
GROUP BY host_name,program_name,login_name ORDER BY 4 DESC

3) I created an alert - included the job from above. Type performance condition alert. Object - SQL Server General Statistics. Counter - User connections.Alert if counter rises above 50. Just testing. I really want to know when it gets past 2500.

4) I've set the alert to email and delay is between responses 2 minutes.

It history tables says number of occurences is 18964. However, I don't receive an email.

Shouldn't the alert send an email? Do I need to include email code in the job?

View 6 Replies View Related

How To Send Report Through Email One Time I.e. Without Subscription For Recurrent Emailing?

Jul 10, 2007



I want to send a deployed report (report manager), through email, by calling reportingServices webservice. But the requirement is that, time is not fixed for sending this email, so I want to trigger the sending of report as a one time event, no subscription to a daily time...

How should I go about it?

View 1 Replies View Related

Transact SQL :: Emailing Session Events For Extended Events

Feb 3, 2014

I am using this code for LongRunning Queries.

CREATE EVENT SESSION LongRunningQuery
ON SERVER
ADD EVENT sqlserver.sql_statement_completed
(
ACTION (sqlserver.sql_text, sqlserver.tsql_stack)
WHERE sqlserver.sql_statement_completed.duration > 60000

[Code] ...

Here Instead of writing to XML file how can send an EMAIL if a query runs more than 1 minute in my server ?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved