I do agree to Grant and Jeffery. In addition I will check the indexes used in the execution plan. Check for the 'estimated' and 'actual' rows, which can tell if...

I would use SSIS. It will give you flexibility to add your custom text as a top row and total count. Also the SSIS can be wrapped up in the...

please check the article -

https://docs.microsoft.com/en-us/sql/t-sql/functions/dense-rank-transact-sql?view=sql-server-ver15

The trace file along with the Execution plan will be more useful to explain your question about the execution time. 
But anyway, according to the trace, the procedure is performing...

I couldn't open your attachment in the profiler. Can you verify your attachment?

I do see the outer procedure has many "reads" than the inner procedure. Are you performing...

Your script worked on my server . I got actually list of failed jobs in emails. Can you check your email profile name and email addresses?

Try this . This helped me --

http://www.aspsnippets.com/Articles/The-OLE-DB-provider-Microsoft.Ace.OLEDB.12.0-for-linked-server-null.aspx

after reviewing the execution plan I think there are few things which we can take care of, for performance -

1. Index IX_Portfolio, on the table dbo.Portfolio needs to be...

--disable specific key

ALTER TABLE dbo.table1

WITH NOCHECK

NOCHECK CONSTRAINT [FK_table1_keyColumn]

GO

-- Enable specific key

ALTER TABLE dbo.table1

WITH CHECK CHECK CONSTRAINT [FK_table1_keyColumn]

GO

Can you check the output of your procedure? check the HTML. if the HTML is null then the email will not be received.

declare @userid nvarchar(10);

select @userid = '001';

select @user-id, ProdID, ProdTitle, ProdType

from Prod_T pt

where not exists (select 1 from User_Prod_T upt where upt.ProdID...

;

WITH MScte

AS (

SELECT h.server,

h.job_id,

h.run_duration,

h.run_date,

h.run_time,

CASE LEN(h.run_duration) WHEN 1 THEN '00:00:0' + CONVERT(CHAR(1), h.run_duration)

WHEN 2 THEN '00:00:' + CONVERT(CHAR(2), h.run_duration)

WHEN 3...

1. check the execution plan for all the queries.

2. Check if there is a index on date that you are using to filter the data. if not, then create a...

There are quite a few good articles on the internet with examples.

https://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

select name, object_name(object_id) As ObjName,*

from tempdb.sys.objects

where name like '#%'