I have a job that calls it once a day. It's not being run three times because no one else is getting three emails.
I put her in for a CC on the employee copy, and she gets only one, and is happy with that.
I still wish I knew what the heck was going on with this. I've pored over it so many...
USE [HR]
GO
/****** Object: StoredProcedure [dbo].[sp_SendOutEmailForEvalDue1Month] Script Date: 02/01/2011 12:24:22 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
/* =============================================
Author: SP
Create date: 2/5/2009
Description...
Well, I'd prefer to know why it keeps doing what it's doing for future reference, but that doesn't appear to be in the cards.
So I'm just going to add her as a CC on the one that goes to the employee. Thanks, djj55 for reminding it was a possibility (I coded this originally two years ago, and...
Because HR wants different text to go to the different parties involved. Otherwise that would be a lovely, elegant solution, but I couldn't get HR to accept it. :)
I have a series of stored procedures that grab a list of everyone who has an evaluation coming due in a specific time from the current date, and it sends the person and their supervisor an email. The code uses a temp table populated from a different stored procedure, and then uses a cursor for...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.