I don't know much about broker service so I have question. We have a content management system the we developed locally, and what we have are catagories and subcatagries. When people choose a topic we send them an email about the topic they are interested in. We are now selling webinars and white papers and articles on demand. We would like to be able to send a reminder email to anyone who signed up for a webinar or special event. Is this possible with broker service?
When records are initially created, they are given statuses of New, Pending, Closed
By default, the status is New.
If no action has been taken after 15 days since the records were created, users are sent a reminder.
I have this part working.
The problem is that as long as the status is not equal to closed, start sending reminders every 10 days.
Here is what I am working with:
SELECT [ID] , [Name], [Email], Status FROMmyTable WHERE Status_Name != 'Closed' AND Status_Name IS NOT NULL and Status_Name = 'New' and Status='Pending' AND CONVERT(Char,DateAdd(day,-15,getdate()),101) = CONVERT(Char,Date_Entered,101)
Hi Experts, I have a table with fields: remindWHO remindWHEN remindWHATsomeone@test.com 6/20/05 do blah blah I want SQL Server Agent automatically run every morning at 1:00 AM, check against "remindWHEN" date, if match with current date, send out email to "remindWHO" for what they need to do in "remindWHAT" I was told this can be done by using the "Jobs" feature under SQL Server Agent to do this, but I don't know how to write Transact-SQL-Script under "Job Step". Please help me. Or any better alternative?I appreciate for any help.
Hi there,I need help with setting up a reminder in my sql.It needs to check the inventory on hand for a product and if it isbelow 3 unit, it needs to send an e-mail reminder to the user.how do I set this up?Thanks,
I'm currently working on a big report project. There is a main report and about 15 subreports in that main report There is nothing more than subreports in the main.
Since sub-reports are very similar from one to another, i'm trying to find a way to remind at every page the name of the subreport which is currently displayed.
I've tried two solutions... doesn't work :
A textbox on the main report... but only the name of the main report is available A textbox on every subreport... but then, the name of the subreport appears only at the end of the subreport, which comes oftently after more than 10 pages.If someone should help for that, i would be grateful.
Rod
PS : don't hesitate to ask details, my english might not be perfect
Hi guys,I hope somebody can help as I am trying to write a procedure in SQL that will be an email reminder sent to users on every 5 th or the month if they don't submit data before.
I am quite new to sql and procedures in particular so I was hoping somebody can help.
I need to: 1.Check the day of the month, if not 5th do nothing
2.Get the date of the prevoious month (get current date - 1 month,set day to 1)this is the funny bit. I have a field DateEntered,but users only select the month and the year on the acctual page,but when submitted it gets written as a full date and defaults to the 1st of the month.
3.Get the list of hospitals that haven't got data for the previous month
How do I indicate a post answered my question? While reading a reply to your question you will notice a button with this Icon: Clicking on it will mark the post as the answer to your question
fetch next from emailCursor into @Name,@info, @Recipients,@MyMessage
end close emailCursor deallocate emailCursor
Currently I have two users in my table that I want to send email to, but when the stored procedure runs I got two emails for the last user in the table instead one for each user.
Since upgrading from SQL Server Management Studio 2008 R2, I've noticed that it no longer autosaves queries that have not been manually saved first. If a file has been manually saved the autorecover files end up in the following directory:
%appdata%MicrosoftSQL Server Management Studio11.0AutoRecoverDatSolution1
However, I have ended up in the situation where I have unsaved queries when my computer has crashed and have not been able to recover them.
I have also found references to .sql files stored in temp files in the following directory, but the files here seem to be very haphazardly caught:
I have an MS SQL Server table with a Job Number field I need this field to start at a certain number then auto increment from there. Is there a way to do this programatically or within MSDE?
Hi, looking for some help on job notification emails in SQL 2005.
I've created a backup job in the Maintenance Plan section of SQL2005, and added a "Notify Operator" task to notify me when the job completes. I've setup Database Mail, and I am getting the notification email whenever I run the job. So this is working fine.
The problem is when I got to the 'Jobs' folder, and into the properties of my backup job, I set it up to notify me from the notifications option, but I am not getting any emails. For now I have set it to notify me when the job "succeeds".
Any ideas why it works from the Maintenance Plan section, but not the "Jobs" notification section? Am I forgetting something?
I have recently migrated a SQL2000 instance to SQL2005, and would now like to setup all the existing jobs to notify me if they fail.
Hi I am using asp.net framwork 2 with sql 2005 express edition. Can anyone please provide me any sample of sending automated emails (like welcoming people when they register to my website, or if their personal details have been updated....). or any e-book/website ref will do. I am not very expert in sql/db and smtp (or other email) stuffs. So please help me. With thanks
How would I go about checking incoming e-mails? For example, on a certain e-mail address, I would get e-mails formatted in a certain way. According to the response, some scripts need to run/ some sql tables updates etc. How can one do this in (ASP) .NET with SQL Server? Anyone did this kind of stuff before?
I'm new to programming and to databases so apologies if this sounds like a stupid question.
I have a html page with a simple javascript function that uses the href mailto tag to send an email to a normal email address. I was wondering if it would be posssible to send the email directly to an SQL Server database, without having to pass through an intermediate parsing app. It would mean assigning an email address to the database. Is this possible with SQL Server? I know there would still be problems with parsing the email content to the appropriate fields, but would the sending of the email to the database in itself be possible?
I haven't much experience using databases and I don't currently have access to the SQL Server Express database that will be used to store the email content, so I'm not sure how difficult an operation this would be. I've looked on the internet but I haven't been able to find anything. I was hoping someone here might have done something similar, either with SQL Server or with any other database.
I'm trying to remove emails from a table but the simple update query I wrote doesn't seem to do it. I figured I'd test one record instead of the entire dbase. I've probably given more info than needed (the select statement) but wanted to give a frame of reference.
SELECT Name.ID, EMAIL, COMPANY, MEMBER_TYPE FROM APSCU_PROD.dbo.Name
Hi, folks. I'm fairly new to SQL Server, so forgive any stupidityinherent in this question. I work at a university and a certainfaculty member would like to have her students create a simple auctionweb site as an exercise. As part of the assignment, she wants theauction site to be able to send an email to a bidder when they havebeen outbid.So she has asked me if this is possible, and how to do it. I've read abit about sending an automated email from SQL Server, but I can't findanything about how to trigger the email based upon a field comparisonin the database. I also don't know how to incorporate a field value asa variable into the body of the email.Of course, I don't expect anyone to solve my entire problem in thisforum. I was just hoping that someone could point me in the rightdirection. Can anyone give me any advice about where I should belooking for such info? Can you recommend a web page, or some otherreference material? Is there a specific terminology I should be usingwhen I search? I just don't seem to be able to find what I need.Please reply to Join Bytes! -- I don't read newsgroups regularly.Many thanks in advance!--Sue
Is there a way to automatically import incoming emails into a SQLServer Database?I know it is inefficient, but we have to run a number of rules on theemail after it is received. Store it in a database and be able toconnect other things, meetings, contacts, etc. Moving it back andforth in chunks can be difficult and the overhead could spiral out ofcontrol.So we were thinking of moving it to the DB as it was retrieved.What do you think would be a better solution to retrieve it?Does my email make sense?
Just wondering if there are other people getting mail from Pinnaclesoftware demanding payment of $179 for a subscription that they didn'trequest. I am now on the"Fourth Notice - Invoice past due"I know only one other SQL Server DBA and that person is also gettingthe mail each month. Information on the invoice says the paymentshould be made to Ragan Communication. Is there anyone else out therewho's getting these mails demanding money. I personally find itdisgusting that the company operates in this fashion.
We have SQL server 2005 Reporting Services SP1. In Report Manager I have a shared subscription that runs every hour between 8am and 6pm (I created the shared subscription in Report Manager, then modified it in Sql Server Management Studio to run the hours I wanted). I have a second shared schedule that runs Tuesday and Friday at 7am. For 2 separate report subscriptions - one uses the hourly schedule and the other uses the 2-day schedule, the first time they run during the day it sends 2 email - after that it sends only 1 email, as it should. I created a subscription to email a report when the report content is refreshed from a report snapshot. In Properties...Execution, I selected to render this report from a report execution snapshot, and selected my shared schedule. For the History property I have selected Allow report history to be created manually and Store all report execution snapshots in history; I am not using a schedule to add snapshots to report history in the History property.
When I look at the job in Sql Server Management Studio, it has only ran once each hour. When I look at the snapshot history, there is only one record for each hour. Why is the first scheduled instance sent twice instead of once?
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??
I need to send multiple emails to recipients one at a time what is the best way to do this?for example i do a select statement to get 5 email addresses, now i need to be able to fire off an email with verbiage to each one of them separately. The reason they have to be separate is in the verbiage i need to have there name in the 'Dear Jondoe1,' Here is my second dilemma. How would you insert a name in the verbiage for each email?
Not sure if this is possible, I have a requirement, when email comes into our MS outlook Inbox, we need to identify the email based on the From email address and read the data which is in the body of the email. I do'nt know if we can do something like that using SQL 2005, any ideas?? Thanks!!
I have a stored proc I am running, and I would like to create a list of email addresses from a table and put that list into a variable. I did a basic while loop to work on syntax, but now I don't know how to actually get each address added on. Here's how I started it
declare @start int, @testEmail nvarchar(2000)
set @start = 1 set @testEmail = NULL while @start <= (Select count(PADM_Email) from PADM_Emails) Begin --Print @start set @testEmail = @testEmail + (Select distinct PADM_Email from PADM_Emails) + ';' set @start = @start + 1 End
I know that the above is wrong, but I don't know how to get it right. Ideally, I want the @testEmail to look like this:
Hello, I just joined the forum and consider myself a SQL beginner. I have installed and supported, run backups and similar, but haven't done much with queries and scripting.
I have a MS SQL 2000 server with a company database on it. Amongst other things, the database contains names, birthdays and e-mail addresses. How difficult would it be to setup an automated query to run every morning comparing birthdays to the current date and send automated e-mails out to matching people saying "Happy birthday ...."?
I am setting up a data driven subscription to send out an email which includes a report. The Sql for the data driven subscription outputs the EmailTo, Subject, Comment(Body) and some report parameters. My issue is with the Comment (Body) field which I would like to format with CR/LF to make the email body look neat and readable. I've tried many different permutations of inserting the CR/LF, From concatenating Char(13) + Char(10) in which the email does recognize the Cr/LF to concatenating binary 0x0D + 0x0A which after the first concatenation of binary nothing else can be concatenated. Here is the code I've tried: ---~~~~~~~~ declare @iEndDate datetime set @iEndDate = dbo.fn_today() Declare @Account_group int Set @Account_group = 999 /* DECLARE @mybin1 binary(5), @mybin2 binary(5) SET @mybin1 = 0x0D SET @mybin2 = 0x0A */ Declare @CrLf VarChar(5) set @CrLf = CHAR(13) + CHAR(10) Declare @Str1 VarChar(255) Declare @Str2 VarChar(255) Declare @Str3 VarChar(255) Declare @Str4 VarChar(255) Declare @Str5 VarChar(255) Declare @Str6 VarChar(255) Declare @Str7 VarChar(255) Declare @Str8 VarChar(255) Declare @Str9 VarChar(255) Set @Str1 = 'Good Morning,' Set @Str2 = 'We are exposed by ' Set @Str3 = 'Attached please find the margin call detail.' Set @Str4 = 'Please let us know if you have any questions.' Set @Str5 = 'Thank you.' Set @Str6 = 'Please respond to:' Set @Str7 = '' Set @Str8 = '' Set @Str9 = '' declare @t table ( EmailTo VarChar(255), ReplyTo VarChar(255), Subject VarChar(255), Comment Text, Account_group Int, Trading_Account_Id Int, Broker_Code_Ky VarChar(255), EndDate Datetime ) insert into @t select EmailTo = '', -- isnull(bf.firm_email,''), ReplyTo = '', Subject = 'Margin Call Notice: - ' + Trading_account_name + ' - Exposure: ' + '$' + Convert(varchar(20), convert(Money, Mark_amount),1) , Comment = @Str1 + @CrLf + @CrLf + @Str2 + '$' + Convert(varchar(20), convert(Money, Mark_amount),1) + '.' + @CrLf + @CrLf + @Str3 + @CrLf + @CrLf + @Str4 + @CrLf + @CrLf + @Str5 + @CrLf + @CrLf + @Str6 + @CrLf + @Str7+ @CrLf + @Str8 + @CrLf + @Str9, Account_group = @Account_group, Trading_Account_Id = trading_account_Id, Broker_Code_Ky = EGS.Broker_Code_Ky, EndDate = @iEndDate from fni_ExposureGovernmentSummary (@iEndDate) EGS join broker_group bg on EGS.broker_code_ky = bg.broker_code_ky Join broker_firm bf on bg.fbe_firm_id = bf.broker_firm_id Order by Broker_Group_Name, Trading_account_Name select top 2 * from @t
--~~~~~~~~~~~~~
The Email my company is using is Lotus Notes.
The Question is how do I code the the Comment field so that my email will recognize the Cr/LF.
Is there somewhere that I can change the links that are included in subscription emails? The link that goes out is incorrect because the port number of the server is not included in the link, so I'd like to edit this. Does anyone know where this can be done? Thank you!
I developed a mass mailing tools, but all mails received in junk and spam folder
I use an store procedure 'sp_send_dbmail' which is by default in sql server, when i send an testing mail using object explorer ->Database mail -> right click -> send testing mails, then this mail received in inbox, but when i call 'sp_send_dbmail' this procedure using job with 2 min intervals then mails received in junk or spam folder of recipients..
I configured correctly all information of smtp details ip address...
i got stuck, while sending emails using store procedure sp_send_dbmail, when i m sending simple text format then mail received in inbox but whenever i m trying to send an html format emails with links of images and href tags mails received in spam.. i store procedure is given below..
I am just trying to decipher this sql and the only thing I do not understand what is going on here is what the "input" key word is doing below. I believe its loading all of the select into the table ##OrderEmails, what is it doing?
Hi, with some help today I was able to get my stored procedure runningand have the results emailed to me. However, this is how its showingup:Accounting_Year WK_IN_FYEAR LocationGL_AccountCol Data Difference--------------- ----------- ------------------------------------------------------------------ -------------------- --------------------2007 49 Test1500-001-2587872.0200 -2587872.0200 .00002007 49 Test2500-001-3344713.5000 -3344713.5000 .00002007 49 Test3500-001Is there anyway to line them up side by side properly? When i have twocolms selected the format comes out ok. Thanks for all the helpagain!Here is the sp:CREATE PROCEDURE [dbo].[spEmailVariance](@SubjectLine as varchar(500),@EmailRecipient VARCHAR(100))ASDECLARE @strBody varchar(5000)set @SubjectLine = 'Weekly Flash Update'SET @strBody ='Select statement'exec master.dbo.xp_sendmail@recipients= 'XX@XXXX.com',@subject= @SubjectLine,@query = @strbodyRETURNGO
Hi I have report subscription to send mail to external emails. It works fine for Internal email id's, external email id's doesn't work. Any body knows what configuration changes we need to do. Please let me know if any body knows. Thx vijji
