Reminder
Jul 25, 2006Hi,
How to i get reminder of a number?Is there a function like MOD?
ADVERTISEMENT
Help With Setting Up A Reminder
Dec 10, 2007Hi 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,
View 1 Replies View RelatedSubreport Name Reminder
Nov 29, 2007Hello !
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
Auto Reminder Emails?
Mar 30, 2007I 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?
View 4 Replies View RelatedProcedure To Send An Email Reminder Help?
Apr 21, 2004Hi 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
4.Email the hospitals.
DECLARE @returnDay int;
DECLARE @DateEntered datetime;
SELECT @returnDay = DatePart(day,GetDate())
If @returnDay = 5 (syntax error near 5)
BEGIN
SELECT @DateEntered = GetDate() - 30
Print DatePart(month, @DateEntered)
I was hoping somebody could look at this and help me.
thanks
Reminder - Please Indicate If A Reply Has Answered Your Question.
Jun 10, 2005How 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
Thanks!
Clifford Dibble
SQL Server Agent - Auto Email Reminder
Jun 17, 2005Hi 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.
SQL Server 2008 :: Reminder Emails - Records Created With Status
Jun 29, 2015We have a difficult requirement.
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)
Sending Email Reminder To Multiple Users - Cursor Not Working Correctly?
Sep 18, 2014I am tring to send an email reminder to multiple users using a cursor.
declare emailCursor cursor for
select name,info,default_email, @MyMessage
from My_Temp
open emailCursor
fetch next from emailCursor into @Name,@info, @Recipients,@MyMessage
while(@@FETCH_STATUS = 0)
begin
-- select name,info,ins_default_email,@MyMessage
--from temp
EXEC msdb.dbo.sp_send_dbmail
@profile_name = 'Hello',
@recipients = @Recipients,
@from_address = '<address.com>',
@Body = @MyMessage,
@subject = 'Subject'
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.