Trigger or Notification

Jagjit Saini

4y861

I want if record added/updated in particular table before a particular date say 30/03/2022 i should get message or notification or email should go.

Log should also get maintained of that entry

I want email should go and if date entered is < 30/03/2022 Below is the code

CREATE TRIGGER dbo.TRG_Users_ChangeTracking
ON dbo.Users
AFTER INSERT
AS
BEGIN
SET NOCOUNT ON;

INSERT INTO ChangeTrackingHistory(UserID)
SELECT i.UserID
FROM inserted AS i;
END
GO

Thanks

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Nitin Sontakke4y ago
In general and in scenarios like these in particular, always keep 'abstraction' in mind. Meaning DO NOT expect to do EVERYTHING in one go or at one place.

I would insert a record in particular table with all the relevant information recorded which could be helpful in sending the mail.

Another program / process will keep on polling this table to see if any mail is pending to be sent and will send it and either remove a record from this table and insert in another _History table or mark one of the columns as being processed = true.

Hope you get the idea. Implementation is left to your imagination.

Hope it helps!
0