@ScottPletcher, @grant

Yes, it has to be an email address.

I will be needing it to be in this format as below.The respective network gateway domains will be sending text messages to...

• This reply was modified 4 years, 9 months ago by mtz676.
• This reply was modified 4 years, 9 months ago by mtz676.

Thanks @scott

I was using dateadd but not the way you built it and hence did not work.

And how do I get the message to the right person

EXEC msdb.dbo.sp_send_dbmail

@recipients = "@P+@N",...

• This reply was modified 4 years, 9 months ago by mtz676.

CREATE TABLE [dbo].[DND](
[IN] [varchar](50) NULL,
[P] [bigint] NULL,
[N] varchar(100),
[A] [varchar](100) NULL,
[D] [datetime] NULL
) ON [PRIMARY]
GO

insert into [DND].[dbo].[DND]([IN],P,N,A,D) values ('A',1111111111,'txt.att.net','MA','2020-11-24 13:00:00.000')
insert into [DND].[dbo].[DND]([IN],P,N,A,D) values ('B',2222222222,'messaging.sprintpcs.com','MB','2020-11-25 14:00:00.000')
insert...

Thanks, will take that into consideration.

Yes, I agree.5 to 10 minute intervals should be fine. Thanks

@Grant ,

Yes, that was my intention take a chunk of everyday data rows and execute some sql code/agaent job against the table.I am sure the datatable per day will be...

• This reply was modified 4 years, 9 months ago by mtz676.
• This reply was modified 4 years, 9 months ago by mtz676.

this was mistake.How do I take this post down or mark it as duplicate ?

I am trying to build an extract of backup files(full,diff,log) along with locations(without file names as in the query provided here) usingbackupset and backupmediafamily tables.(past 7 days of days should...

that worked.thanks

Thanks.

Yes I do. I thought you meant after I make progress on that script. Anyways here it is.

SELECT
@@servername [ServerName]
,master.sys.sysdatabases.name [DatabaseName]
,msdb.dbo.backupset.backup_start_date [BACKUP START]
,msdb.dbo.backupmediafamily.physical_device_name[FILE Location]
,CASE
WHEN msdb.dbo.backupset.type = 'D'
THEN 'FULL'
WHEN...

Apologies, I was not clear entirely in my first post.

I got the table result from msdb.dbo.backupset, master.sys.sysdatabases and msdb.dbo.backupmediafamily.

I am trying to draw inference from the results and see the...

Yes, I am trying to draw the inference from the results. If necessary I may need to make changes but not yet there.

Close enough and yes .(excepting the auditors part !) I will post code once I make progress.

Yes, not because I did not want to but because it was unfamiliar and difficult for me to understand. Not denying that.

Thank you anyways.