Transact SQL :: Html Email Message Procedure
Nov 5, 2015
I have a table that gets queued up with a list of people for example email, first name, temporary login account and temporary password.How would i create a store procedure to feed these fields into the html message for each record. For example:
Dear <first name>,
Your temporary access is listed below.
Login: <temporary login>
Password: <temporary password>
I am not sure how you insert the data into the html message. It has to be in html because the message has a couple hyperlinks.
View 6 Replies
ADVERTISEMENT
Oct 24, 2007
hi there,
the subject line says it all. is there a way to send nicely formatted html email from within a stored procedure that returns a dataset?
thanks!
chris
View 2 Replies
View Related
Nov 16, 2005
It seems that using the Send Mail Task, there is no option for me to format my email as HTML. I have all my HTML code in a string and need to format my email to send the string as an HTML email. What would be the best way to approach this?
View 6 Replies
View Related
Jun 20, 2001
I have a proc that generates report content, then emails it, to some sales people. I'd like to use HTML to format the report content (bold letters, underlined, tab spaces, etc), but all I see in the resulting email, is the HTML tags with the content. I've tried to find a way to set the "content type" to text/html (like you'd do in VBScript) but that setting is nowhere to be found in xp_sendmail.
Any ideas on how to make this work, or perhaps another way to format the email content from within a stored proc?
View 1 Replies
View Related
Apr 27, 2015
I wanted to implement the feature to send the email in HTML format from SQL. Which option will be more easy and less resource consumption? Like
sp_send_dbmail or sp_OAMethod or anything else?
View 2 Replies
View Related
Apr 4, 2008
Hi, I need help please.
I want to send an HTML Email
I have an Htm file that i want to use as my email body on Send Mail Task
MessageSourceType: File Connection
MessageSource: Email.htm
It sends the email with the file in the body but not in HTML format
it outputs the HTML tags + data
eg: <span style="font-size:9.0pt;">Period: 2008.04</span>
I used the same file in a DTS package & that works fine.
Please Assist!
Regards
View 2 Replies
View Related
Jun 5, 2008
Hi all!
I have a proc which send email as a text. But now I have to rewrite her to send email as html and embed a picture there.
I use DatabaseMail with sp_send_dbmail.
Does anybody know how to sort out it?
If somebody another way to send email as html with picture don't hesitate, say me.
Thanks in advance!
View 10 Replies
View Related
Jan 28, 2014
I have dumped html in a table and am looking to extract email addresses from it. Within the html, the email addresses are followed and preceded by blank spaces. I am playing around with the following code:
SELECT RIGHT(@email, LEN(@email) - CHARINDEX('@', @email)) as Domain
but have been unable to extract whole email addresses.
View 4 Replies
View Related
Aug 28, 2006
We have a DTS package that sends smtp email from an ActiveX script task. The body of the emails are in template files that we read in and then replace values relating to the customer.
I am looking for suggestions of handling this process from an SSIS package. This is what our existing code does.
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
'********************************************************************************************
' Email results
'********************************************************************************************
Dim oRS, objMessage, fTemplate
Set fso = CreateObject("Scripting.FileSystemObject")
Set oRS =DTSGlobalVariables("ToBeNotified").Value
oRS.MoveFirst
Do While NOT oRS.EOF
Set objMessage = CreateObject("CDO.Message")
Set objMessage2 = CreateObject("CDO.Message")
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
objMessage2.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusing") = 2
'Name or IP of Remote SMTP Server
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = DTSGlobalVariables("RemoteSMTPServer").Value
objMessage2.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserver") = DTSGlobalVariables("RemoteSMTPServer").Value
'Server port (typically 25)
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
objMessage2.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpserverport") = 25
'Type of authentication, NONE, Basic (Base64 encoded), NTLM
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
objMessage2.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/smtpauthenticate") = 1
'Your UserID on the SMTP server
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername") = "CustomerService"
objMessage2.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendusername") = "CustomerService"
'Your password on the SMTP server
objMessage.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "cslogin"
objMessage2.Configuration.Fields.Item ("http://schemas.microsoft.com/cdo/configuration/sendpassword") = "cspassword"
objMessage.Configuration.Fields.Update
objMessage2.Configuration.Fields.Update
objMessage.Sender = DTSGlobalVariables("EmailFrom").Value
objMessage2.Sender = DTSGlobalVariables("EmailFrom").Value
objMessage.From = DTSGlobalVariables("EmailFrom").Value
objMessage2.From = DTSGlobalVariables("EmailFrom").Value
objMessage.To = oRS.Fields("ContactEmail").value
' objMessage.To = "me@ourmail.com"
objMessage2.To = DTSGlobalVariables("EmailBCC").Value
' objMessage2.To = "me@ourmail.com"
If oRS.Fields("Rejected").value = 1 Then
'Rejection Message
objMessage.Subject = "electronic request notification"
If oRS.Fields("ProductType").value = "Fixed" Then
Set htmlTextStream = fso.OpenTextFile (DTSGlobalVariables("EmailTemplateRejectedFixed").Value)
Else
Set htmlTextStream = fso.OpenTextFile (DTSGlobalVariables("EmailTemplateRejectedVariable").Value)
End If
Else
'Successful results
objMessage.Subject = "electronic confirmation #" + CSTR(oRS.Fields("ConfirmationId").value)
objMessage2.Subject = "Customer request for hard copy of contract"
'Add Terms and Conditons document
termDocument = DTSGlobalVariables("TermDocumentsRepository").Value + CSTR(oRS.Fields("TermDocument").Value) + ".pdf"
If fso.FileExists(termDocument) Then
objMessage.AddAttachment termDocument
objMessage2.AddAttachment termDocument
End If
If oRS.Fields("ProductType").value = "Fixed" Then
Set htmlTextStream = fso.OpenTextFile (DTSGlobalVariables("EmailTemplateSuccessFixed").Value)
Else
Set htmlTextStream = fso.OpenTextFile (DTSGlobalVariables("EmailTemplateSuccessVariable").Value)
End If
End If
htmlText = htmlTextStream.ReadAll
htmlText = Replace( htmlText , "[OurLogo]" , DTSGlobalVariables("EmailLogo").Value)
htmlText = Replace( htmlText , "[CustomerName]" , oRS.Fields("ContactFirstName").value + " " + oRS.Fields("ContactLastName").value)
If oRS.Fields("Rejected").value = 0 Then
htmlText = Replace( htmlText , "[ConfirmNumber]" , oRS.Fields("ConfirmationId").value)
htmlText = Replace( htmlText , "[OrderDate]" , oRS.Fields("SalesDate").value)
htmlText = Replace( htmlText , "[ProductName]" , oRS.Fields("ProductType").value)
htmlText = Replace( htmlText , "[Months]" , oRS.Fields("TermMonths").value)
htmlText = Replace( htmlText , "[Price]" , oRS.Fields("SalesPrice").value)
htmlText = Replace( htmlText , "[Units]" , oRS.Fields("SalesPriceUnit").value)
htmlText = Replace( htmlText , "[StartDate]" , oRS.Fields("FlowStartDate").value)
htmlText = Replace( htmlText , "[AccountNumber]" , oRS.Fields("AccountNumber").value)
End If
objMessage.HTMLBody = htmlText
objMessage2.HTMLBody = htmlText
objMessage.Send
If oRS.Fields("SendHardCopy").value = True AND oRS.Fields("Rejected").value = 0 Then
' Attach Instructions for Hard Copy delivery
instructionDocument = DTSGlobalVariables("TermDocumentsRepository").Value + "Instructions.txt"
set file = fso.CreateTextFile(instructionDocument, true)
file.WriteLine("The customer has requested a hard copy of their contract to be sent to them.")
file.WriteLine("")
file.WriteLine("Instructions:")
file.WriteLine("1) Print the email")
file.WriteLine("2) Print the attached Terms & Conditions document")
file.WriteLine("3) Mail both items to the address below")
file.WriteLine("")
file.WriteLine("Customer Address:")
file.WriteLine(oRS.Fields("ContactFirstName").value + " " + oRS.Fields("ContactLastName").value)
file.WriteLine(oRS.Fields("BillingAddress1").value)
If oRS.Fields("BillingAddress2").value <> "" Then
file.WriteLine(oRS.Fields("BillingAddress2").value)
End If
file.WriteLine(oRS.Fields("BillingCity").value + ", " + oRS.Fields("BillingState").value + " " +oRS.Fields("BillingZip").value)
file.Close
set file=nothing
objMessage2.AddAttachment instructionDocument
fso.DeleteFile(instructionDocument)
objMessage2.Send
End If
set objMessage = nothing
set objMessage2 = nothing
oRS.MoveNext
Loop
Main = DTSTaskExecResult_Success
End Function
All suggestions are appreciated.
SK
View 1 Replies
View Related
Aug 14, 2004
Could anyone walk me through how to do the following:
Schedule a query to run at a designated time
Embed the resulting table in a HTML email
Email the HTML formated results someone automatically
Can this be done with SQL Server only or is there a third party app?
I know its alot but I'm having a hard time finding resourses.
View 1 Replies
View Related
Dec 2, 2014
I have a job below, which takes the results and send to the users in email.But I have a question, how can I send only one email with all rows, not to send the for every row on table separated email.
DECLARE @Body VARCHAR(MAX)
DECLARE @StartDate DATETIME
DECLARE @EndDate DATETIME
DECLARE @RowCountINT
DECLARE@idINT
declare@departmentnvarchar(30)
[code]....
View 2 Replies
View Related
Sep 30, 2015
I am using the below code to send HTML Email body to multiple recipients and CC, its working fine. Now i have to attach multiple files in that mail. Is there any possibilities to attach multiple files with the below code else provide any other code to achieve this task.
Code:
/*
Microsoft SQL Server Integration Services Script Task
Write scripts using Microsoft Visual C# 2008.
The ScriptMain is the entry point class of the script.
[code]...
View 6 Replies
View Related
Mar 28, 2008
while i was trying to execute the code for Sending an "HTML Mail Message with the Script Task" given at the link below http://msdn2.microsoft.com/en-us/library/ms403365.aspx
following error was encountered.
DTS Script Task has encountered an exception in user code:
Project namecriptTask_098956444e9f4ae195c3565569c9444b
The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there
at Microsoft.SqlServer.Dts.Runtime.Variables.get_Item(Object index)
at ScriptTask_098956444e9f4ae195c3565569c9444b.ScriptMain.Main() in dts://Scripts/ScriptTask_098956444e9f4ae195c3565569c9444b/ScriptMain:line 29
please help me
View 7 Replies
View Related
Oct 3, 2006
I set up the "Send Email Task" succesfully with "SMTP Connection to myExchangeSERVER" using "Windows Authentication"
However, as we all know - you can't have html format for the Send Mail Task. BUT this piece of code straight from MSDN doesnt work for me - each time it pops up this "Mail Sent Succesfully" - but I receive NO freaking EMAILs!!! Am I missing something or is it another one of those Microsoft "gotchas" ?
Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Runtime
Imports System.Net.Mail
Public Class ScriptMain
Public Sub Main()
Dim htmlMessageTo As String = "me.here@mydomain.com"
Dim htmlMessageFrom As String = "SSIS@mydomain.com"
Dim htmlMessageSubject As String = "SSIS Success - My Package"
Dim htmlMessageBody As String = _
Dts.Variables("User::HTMLtemplateText").Value.ToString
Dim smtpServer As String = "myExchangeSERVER"
SendMailMessage( _
htmlMessageTo, htmlMessageFrom, _
htmlMessageSubject, htmlMessageBody, _
True, smtpServer)
Dts.TaskResult = Dts.Results.Success
End Sub
Private Sub SendMailMessage( _
ByVal SendTo As String, ByVal From As String, _
ByVal Subject As String, ByVal Body As String, _
ByVal IsBodyHtml As Boolean, ByVal Server As String)
Dim htmlMessage As MailMessage
Dim mySmtpClient As SmtpClient
htmlMessage = New MailMessage( SendTo, From, Subject, Body)
htmlMessage.IsBodyHtml = IsBodyHtml
mySmtpClient = New SmtpClient(Server)
Dim myCred As New System.Net.CredentialCache()
mySmtpClient.Credentials = System.Net.CredentialCache.DefaultNetworkCredentials
mySmtpClient.Send(htmlMessage)
MsgBox("Mail sent")
End Sub
View 3 Replies
View Related
Jul 20, 2005
I have setup an email notifications system, that basically takes eachrow from a table and sents out an email according to the data in thatrow. The emails get sent, with the subject being filled as expected.Only problem is that sometimes there is no message.Here is the stored procedure that is being called every hour to sendthe emails:CREATE PROCEDURE dbo.RemindersSendEmails AS--CursorDECLARE RemindersCursor CURSOR FORSELECT *FROM RemindersTodaysAndUnsent--Values for cursorDECLARE@I_Reminder_ID bigint,@I_Notice_ID bigint,@V_Reminder_Text varchar(250),@SDT_Reminder_Date smalldatetime,@V_Email varchar(50),@I_Reminder_Type bigint,@SDT_Reminder_Sent smalldatetime,@I_Attempts_Made int,@V_Notice_Type varchar(50),@I_Notice_Period int,@V_Period_Description varchar(50),@I_Project_ID bigint,@V_Notice_Ref varchar(10)--values for sending the mailDECLARE @NEWLINE varchar(2)OPEN RemindersCursorFETCH NEXT FROM RemindersCursorINTO @I_Reminder_ID, @I_Notice_ID, @V_Reminder_Text,@SDT_Reminder_Date, @V_Email, @I_Reminder_Type,@SDT_Reminder_Sent, @I_Attempts_Made, @V_Notice_Type,@I_Notice_Period, @V_Period_Description,@I_Project_ID, @V_Notice_Ref--INTO @I_Reminder_ID, @I_Notice_ID, @V_Reminder_Text,@SDT_Reminder_Date, @V_Email, @I_Reminder_Type,--@SDT_Reminder_Sent, @I_Attempts_Made, @V_Notice_Type,@I_Notice_Period, @V_Period_Description,--@I_Project_ID, @V_Notice_RefSET @NEWLINE = char(10)--PRINT 'start'WHILE @@FETCH_STATUS = 0BEGINDECLARE @EmailMessage varchar(6000), @Subject varchar(100), @StatusintSET @Subject = RTRIM(CONVERT(varchar(8), @I_Reminder_ID)) + ' NoticeAlert - Project ' + RTRIM(CONVERT(varchar(8), @I_Project_ID)) + 'Notice Ref ' + RTRIM(@V_Notice_Ref)SET @EmailMessage = 'Project: ' + RTRIM(CONVERT(varchar(8),@I_Project_ID)) + @NEWLINE +'Notice: ' + RTRIM(@V_Notice_Ref) + @NEWLINE +'Notice Type: ' + RTRIM(@V_Notice_Type) + ' - ' +RTRIM(@V_Period_Description) + @NEWLINE +'Reminder: ' + RTRIM(@V_Reminder_Text) + @NEWLINE + @NEWLINE +'Reminder date: ' + CONVERT(varchar(11), @SDT_Reminder_Date) +@NEWLINE +'Reminder sent: ' + CONVERT(varchar(11), GETDATE()) + @NEWLINE +'Email sent to: ' + @V_Email + @NEWLINE +'Number of attempts made at sending this email (once every hour): '+ CONVERT(varchar(4), @I_Attempts_Made)--@I_Reminder_ID, @I_Notice_ID, @V_Email, @I_Reminder_Type,@I_Notice_Period,PRINT 'subject = ' + @SubjectPRINT 'message = ' + @EmailMessageSET @V_Email = LTRIM(RTRIM(@V_Email))EXEC @Status = master..xp_sendmail @recipients = @V_Email,@message = @EmailMessage,@subject = @Subject--PRINT 'XXXXXXXXXXXXXXXXXXXXXX status = ' + CONVERT(varchar(2),@Status)--If send mail is a successIF (@Status = 0)BEGINUPDATE RemindersSET SDT_Reminder_Sent = GETDATE(), I_Attempts_Made =@I_Attempts_Made + 1WHERE I_Reminder_ID = @I_Reminder_IDEND--Else send mail failedELSEBEGINUPDATE RemindersSET I_Attempts_Made = @I_Attempts_Made + 1WHERE I_Reminder_ID = @I_Reminder_IDEND-- Get the next reminderFETCH NEXT FROM RemindersCursorINTO @I_Reminder_ID, @I_Notice_ID, @V_Reminder_Text,@SDT_Reminder_Date, @V_Email, @I_Reminder_Type,@SDT_Reminder_Sent, @I_Attempts_Made, @V_Notice_Type,@I_Notice_Period, @V_Period_Description,@I_Project_ID, @V_Notice_RefEND--PRINT 'End'CLOSE RemindersCursorDEALLOCATE RemindersCursorGO
View 2 Replies
View Related
Sep 7, 2000
If I want any SQL error message created inside a database to send an error
message is the xp_sendmail the way to go?
View 3 Replies
View Related
Jul 23, 2005
Hi,I am constructing a Message (Body) for sending our Emails. It is around3000 characters long. But for whatever reason, the last line seems tobe broken with a "!" exclamatory mark in it, which results indisplaying the constructed image path as a broken one.How to resolve this ?. Thanks.Regards,Karthick
View 3 Replies
View Related
Jan 2, 2008
I am trying to capture an error message and email to myself whenever the script has an error. I have an email task event handler on OnError and use the variable errormsg as my email body. I have the errormsg variable with a package wide scope defined as string with a value of @[System::ErrorDescription]. Is there anything elso I need to do to make this work?
View 10 Replies
View Related
Apr 23, 2008
Hi,
I have define an "execute SQL task" followed by an "Send Email Task" :
http://img171.imageshack.us/img171/449/pic562qn9.gif
http://img171.imageshack.us/img171/1793/pic564jo2.gif
I want to include the package name that is being executed in the message body of the email, How can i do this ?
I have tried to set an output parameter with Variable Name "System:ackageName", but i get the message :
Variable "System:ackageName" cannot be used as an out parameter or return value in a parameter or return value in parameter ....
View 6 Replies
View Related
Feb 7, 2008
Hello,
Is there a way that I can set up an error handler on a DataFlow so that errant rows within the DataFlow are delivered to a user via email?
I'm looking for Primary Key Violations. In this case, there are two columns of data involved in the DataFlow (AcctCode, RebateRate).
Thank you for your help!
cdun2
View 11 Replies
View Related
Nov 2, 2006
I used onError event to send email in case ssis pckage fails
but it send multiple email with errordescription. for ex below are the errordescription of four diferent emails i received.
Thread "WorkThread0" has exited with error code 0xC0047039.
An error occurred with the following error message: "The connection "{01AF859A-CF97-4F6C-9C78-1AA4B1C9C27B}" is not found. This error is thrown by Connections collection when the specific connection element is not found.".
Thread "SourceThread0" has exited with error code 0xC0047038.
The PrimeOutput method on component "Flat File Source - Read from source file" (1) returned error code 0xC0202092. The component returned a failure code when the pipeline engine called PrimeOutput(). The meaning of the failure code is defined by the component, but the error is fatal and the pipeline stopped executing.
Can anyone suggest if we can combine all this error description and send this as one email.
View 2 Replies
View Related
Feb 15, 2008
Hello,
I have a SQL Task that executes some stored procedure. When a condition is met the stored procedure raises an error by calling RAISERROR (@ErrorMessage,16,1). Following the SQL Task I have Send Mail Task that sends an error email.
I would like to know how to include the @ErrorMessage in the error email.
Thank you,
-Oleg
View 3 Replies
View Related
Feb 28, 2006
How do you set up the service broker to process an email message, and how do you format that message and send it to the que.
Can the service broker alos process an html form from a que.
Thanks
View 1 Replies
View Related
Dec 14, 2007
I have an SSIS package set up to run various SQL scripts and to notify me if any of the SQL scripts fail. This is working fine, but when I get the email it only says that the script has failed. Is there any way to actually show the SQL result with the error in it? This would save me from having to go and manually run the script again to see the error message.
Thanks
Kate
View 31 Replies
View Related
Jun 24, 2015
I have a flat text file with lots HTML tags and corresponding values
For example
<Near_Side> 5563 </Near_Side>
<Top_Down_Code> Xe345 <Top_Down_Code>
So, For example I can use the a function
ALTER function dbo.StripHTML( @text varchar(max) ) returns varchar(max) as
begin
declare @textXML xml
declare @result varchar(max)
set @textXML = REPLACE( @text, '&', '' );
[Code] ...
To which Select dbo.StripHTML('<Near_Side> 5563 </Near_Side>') Value
I'll get 5563
However how would you get the values within the tag itself ? E.g.
Value Name
5563 Near_side
Xe345 Top_Down_Code
I was thinking along the Charindex but cant seem to get it right.
View 4 Replies
View Related
Oct 5, 2005
Hello everyone,
Please i need your help...
I dont know how to place the field 'strTitle and datBorrowed " in my email? Not as an attachment though....Just write it in the mail as part of message body...
I use this SQL select statement to retrieve the strTitle and datBorrowed fields
strSQL += @"Select replace(strtitle,'[Original Book] - ',''), datBorrowed from tblBooks where convert(varchar(10),datBorrowed,101) = convert(varchar(10),(getdate() - 1),101) ORDER BY strTitle asc";
Now, I have the following code to write the email
static void SendTest()
{
int iEmailLanguage = 0;
MailMessage objMail;
objMail = new MailMessage();
objMail.From = MAIL_FROM;
objMail.To =MAIL_TO;
objMail.Subject = "Books Borrowed Yesterday";
objMail.Body = Dict.GetVal(iEmailLanguage, "EMAIL_MESSAGE");
objMail.Attachments.Add(new MailAttachment(strAttachment));
SmtpMail.SmtpServer = SSMTP_SERVER;
SmtpMail.Send(objMail);
}
And the body of the email is this......
Dict.AddVal(0, "EMAIL_MESSAGE", "*** This e-mail is automatically generated. ***" +
"*** PLEASE DO NOT REPLY TO THIS E-MAIL. ***" +
"" +
"Books Borrowed Yesterday are:" +
"" +
"" +
"Thank you," +
"" +
"eLibrarian" +
"" +
"================================================== ===============" +
"" +
"This e-mail is automatically generated by the Library system." +
"Please do not reply.");
i need to put or wedge the data i got from the SQL Statement into this or after the line "Books Borrowed Yesterday are:" +
So how should i do this?
View 3 Replies
View Related
Jun 25, 2014
What I am trying to do, Extract the data from SQL table and Insert in Email Body and email to user. I got good article on Internet, I follow all steps as it is, but still I am getting error.
Here is the link : [URL] ....
But I am getting Error:
Error: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.FormatException: Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
at System.Text.StringBuilder.AppendFormat(IFormatProvider provider, String format, Object[] args)
at System.String.Format(IFormatProvider provider, String format, Object[] args)
at ST_7f59d09774914001b60a99a90809d5c5.csproj.ScriptMain.Main()
[Code] ....
View 4 Replies
View Related
Jun 17, 2015
Exec Prcoess task with source : ftp
destination :ftpunzip
work directory ftpunzip
executable : c:Program FilesWinZip
i am using expressing.
It is doing the unzip but getting this error
package process on server server1 has failed within the Task 'Unzip Files' with the following errors:
>
> File/Process "WZUNZIP.EXE" does not exist in directory "c:Program FilesWinZip".
This is the error message i am getting it
View 6 Replies
View Related
Jul 2, 2015
I have one PS script; Basically it reads all application logs and give a report. Here is the PS script:-
$logs='C:AppLog*.log'
$ufo=Get-Date -ufo '%Y-%m-%d' # Unidentified Flying Object
$match="^$ufo.+error.+$"
sls $match $logs|
group filename -noe|%{
[pscustomobject]@{Name=$_.name;Date=$ufo;'#Errors'=$_.count}
[code]..
Now I would like to setup a SQL job and want to get the result in email.
View 5 Replies
View Related
Jan 3, 2007
I am trying to find a way to implement a page refresh using an SQL Server procedure for an HTML Page. The user will indicate the time for refresh and this would be genereated using the stored procedure..any ideas?????
View 2 Replies
View Related
Aug 28, 2006
I presently have a Access macro that emails conditionals in a report to users in web format HTML. I would like to turn that into a stored procedure, but having some difficutly can anyone out there assit me please??
View 1 Replies
View Related
Jun 21, 2015
How can I turn this query into an Email alert if one of the counts are GT 50. The Source are machines that I capture counts(Unprocessed_Cntr) from every 5 minutes and load to the Load_Time_Capture table. I also add a datetime to each capture(Unprocessed_Capture ).
If any individual source has a count > 50 or if the combined(ALL) GT 50 send an email to support person.
SELECT
CASE GROUPING([Source])
WHEN 1 THEN 'ALL'
ELSE [Source] END AS 'Input Source',
avg([Unprocessed_Cntr]) as 'Average Queue Past 15 Min'
FROM Load_Time_Capture
WHERE Unprocessed_Capture >= DateADD(mi, -15, Current_TimeStamp)
GROUP BY [source] WITH ROLLUP
View 4 Replies
View Related
Aug 13, 2015
I am getting email from the end client and i need to validate in sql query.
View 3 Replies
View Related