Thank you Michael - sorry for not responding sooner.

Yes it will be really helpful if I could have a trigger or a stored procedure to check every time a new...

One thing that might be a factor is the SQL server version as it is a difference in the current set up I am attempting compared to other ones I...

• This reply was modified 1 year, 3 months ago by  RegzP.
• This reply was modified 1 year, 3 months ago by  RegzP.

Thank you @AntGreen and Jeffrey.

OK, I just want to ask, how is the best way to set this up? I tried doing it as an SQL job and then SSRS...

Thank you for trying to help. OK so this is what the query in the report looks like;

SELECT [ID]

,[MessageTypeID]

,[EventID]

,[Source]

,[Destination]

,[Subject]

,[MessageText]

,[MessagePlainText]

,[CreatedOn]

,[UpdatedOn]

,[Provider]

,[LanguageCode]

,[SmscMessageID]

,[SmscStatus]

,[SendRetryCount]

,[MessageStatusID]

FROM [UT_XXX_Core_XXX].[messaging].[MessageQueue]

WHERE Source = '277' AND (DATEADD(month, 1, UpdatedOn) >= GETDATE())...