.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Email sql job data

Posted By:      Posted Date: October 18, 2010    Points: 0   Category :Sql Server

Currently am checking my data using sql jobs. Assume if a new record

is inserted into db,it should have to receive ack in 2 hrs.Orelse

we need to intimate  client via email alerts. such that particular message

has not been processed,This can be check by STATUS value in db.


Suppose after retrieving these data how do I send as email with the records(which are not received ack) to my client.Am having query//but how can I configure my client email id and send them?

Can any one have any ideas?

View Complete Post

More Related Resource Links

Linq - add data to database then email user the details


Hi all

I'm not sure how to structure the code for this but what I want to do is be able to add data to a database, and once this has completed successfully, then email the user to say the details have been added successfully to the database.

I need to:

1. Check that the relevant data has been added into the database then

2. Email the details of the relevant data when completed. 


Thanks in advance for your help,




Send an Email with User fields data entered in the form


Hi All,

          I have a form which have some user input fields(like textboxes,dropdownlists,textarea etc) fields and a submit button.

on click i need to send email with body contents as all the details entered by user in the form

Can anyone suggest how i should approach to this in sharepoint..

any code examples would be appreciated.


Library - Fill Columns with data from email

I have an inbound email enabled Library.  The Library has several columns created for it.  I would like to be able to send an email into the Library and have these columns filled from information in the email.  Is this possible using WSS 3.0?  What are the basic steps?  If I understand SharePoint well enough, I'm guessing is that I have to include the columns as Metadata in the body of the email and then assign this Metadata to the appropriate Library columns when new email is uploaded to the Library.

Excel sheet is not saving data while sending email

Hey Guys,  I am creating a SSIS package, where I am getting all the data into the excelsheet1, which is not formatted. So i created a formated excelsheet2, where i am giving reference to excelsheet1 cells reference. And I am sending email by attaching excelsheet2.              I am having issue when the data is updated, but my email attachment excel is showing old data. When i open the excelsheet1 it is being updated. I don't know why excelsheet2 is not updated automatically. I am using BIDS 2005 . Can anyone please suggest what will solve my problem. Thanks in Advance Priyamvadha

putting data in a format send by email

Gooday If i want to send my data to someone by email so as they can update the data into their database , how can i do this . The database is too big to send by email? thanks Robrh

How do you extract data from the xml attachment of an incoming email and set it as metadata in a doc

Hi, I currently have a document library that contains InfoPath forms. As a form is loaded into the document library I need the data to be extracted from the infopath file and then set as properties/metadata of the file. The infopath forms will be sent to the SharePoint site as an email attachment. So basically, an email is sent to the SharePoint server with an InfoPath form as an email attachment. The InfoPath form needs to be extracted from the email and uploaded to the document library and at the same time updating the document library metadata with the infopath form data. This has been done using Visual Studio but can this be done using SharePoint Designer 2010 now that we have upgraded our site to SharePoint 2010? Any guidance will be greatly appreciated! Thanks Michael

How to get Email of Current User Data View Web Part Sharepoint 2010 and pass to WebService data sour

I have to pass in the email address of the current user to a web service data source (run time) of a Data View Web Part.

My Question is:

a) How can I get Email address of current user based  in DVWP.
I know we can get the CurrentUser using the CurrentUserName but how do we get the Email for the Current User.

b) After getting the Email how do we pass to the Web Service.

Error for delivering a report via email by using the data-driven subscription



I have created a SSRS 2005 report to export in the Excel format as a batch execution. I have made a data-driven subscription, I have specified the from mail address (with my address) and the smtp server in the RS configuration tool, I have set the SQL Server Agent account with my domain user, but I have an error about the from address is refused from the server and the client was not authenticated. I have tried to specify the IP for the smtp server.

Any suggests to me in order to solve this issue, please? Many thanks

Data Driven Email Settings reg

Dear All, I am trying to subscribe a report to some particular email ids. I am using Data Driven Subscription. Have set the recipients are to be notified by E Mail & have mentioned a shared datasource and have specified the query which will have some email ids in a particular column. In To address have specified a static id and for CC have chosen the column of email id from db. And render format pdf,.. and so on but nothing is getting processed and no mail is sent. as Our smtp is remote, have done the corresponding setting in the config file. Kindly let me know where iam wrong? Thanks,
--------------------------- Radhai Krish | Golden Age is no more far | --------------------------

How to add a field data onto an email table?


Hi VB newbie here. How can I call my TextBox ID = "txtFromAddress" data to a table that I am trying to send? Right now it is just showing the text '& txtFromAddress' on the table on the email that I send. Thanks in advance.


<table><tr><td><b><font color = 336699>Contact Information</b></font></td><td></td></tr><tr><td>Contact Name</td><td> & txtFromAddress </td></tr></table>

Contact Information
Contact Name & txtFromAddress

Workflow email and the link to collecting data page



I’ve created a workflow in SharePoint Designer 2007. The workflow is collecting data from user and update the item in the current list and is running ok to send Task Notification email to the user.

My 2 questions are:


1. How to customize the email?

Here is the notification email:

Task assigned by [Admin’s Name] on 10/20/2010.

To complete this task:

collect data from user - email problems


I have a WF with a Collect Data from user action. It works perfectly - creates a task and sends the email.

I moved the site collection by stsadm -o restore to a different server. The Collect Data from user action fails to send the emails now - the task gets created successfully but no email gets sent.

I have added a Send email message action just before the Collect Data from user action and it just sends an email to an email address and this works fine. It just fails to send the email from the Collect Data from user action.

  • the email outgoing settings are correct and work.
  • The task list is set to send emails when an owner is assigned.
  • I am triggering the WF's using an admin account, so I have Full control permission
Is there anything else it could be?

Data Change Captured in an email.


I have a list item where employees in my company maintain their contact information like addresses, phone numbers and emergency contact details and things like that.  I created a workflow in SharePoint Designer that sends out a notification to the team lead with the email content that prints the 'title' and the 'modified by' when a list item is modified or a new one is created. Now, I was hoping if someone can tell me if there's a way to capture which field is changed(while editing) and how to pass that on to the email content. 





Binding WPF Controls to an Entity Data Model

In this interview, programming writer, McLean Schofield, demonstrates how to bind WPF controls to an entity data model, using Visual Studio 2010 Beta 1. You can also learn more in the topic: Walkthrough: Binding WPF Controls to an Entity Data Model.

Surrogate vs Natural Primary Keys - Data Modeling Mistake 2 of 10

In case you're new to the series I've compiled a list of ten data modeling mistakes that I see over and over that I'm tackling one by one. I'll be speaking about these topics at the upcoming IASA conference in October, so I'm hoping to generate some discussion to at least confirm I have well founded arguments.

The last post in this series Referential Integrity was probably less controversial than this one. After all, who can argue against enforcing referential integrity? But as obvious as surrogate keys may be to some, there is a good deal of diversity of opinion as evidenced by the fact that people continue to not use them.

Editing the Data in a GridView

In addition to deleting a GridView's underlying data, another common need is to allow end users to edit the data displayed in a GridView. With ASP.NET 1.x's DataGrid control, editing the data is certainly possible, but requires creating three event handlers and writing a dozen or so lines of code. With the GridView and ASP.NET 2.0, it is possible to create an editable GridView without writing a single line of code! All of the necessary functionality is encapsulated within the GridView.

The GridView allows editing on a row-by-row basis. An editable GridView contains an additional column with an Edit button in each row. When the end user clicks on an Edit button that row becomes editable, causing the Edit button to change to Update and Cancel buttons and the other columns to become TextBoxes. The end user can then update one or more column values and click Update to save their changes.

Using ASP.NET 3.5's ListView and DataPager Controls: Displaying Data with the ListView

Prior to ASP.NET 3.5, developers who needed to display a set of records could choose between the GridView, DataList, and Repeater controls. The GridView provides rich data features, but has a very boxy layout; the DataList and Repeater allow for a more flexible layout, but lack the "point and click" data features found in the GridView, DetailsView, and FormView controls. The ListView bridges the gap between layout flexibility and built-in data features.

This article, the first in a series of articles on the ListView and DataPager controls, looks at the ListView's many available templates and illustrates how to display data. Read on to learn more!
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend