Viewing 15 posts - 181 through 195 (of 628 total)
Thank you.
That is one of the index on session lock table in report server temp db.
How can we reduce this waiting several sessions for that particular resource?
December 17, 2015 at 9:41 am
Hi,
Thanks for your replies.
I am working the similar kind. I am using the same query but just the columns are different.
In the query there is an end time, which has...
December 7, 2015 at 11:44 am
Thank you
December 3, 2015 at 3:51 pm
Thank you.
I miss that ,'' and changed later.
Here SET @body ='<html><body><H3>All Jobs Run Status</H3>
what does it do when we use H3?
December 3, 2015 at 2:05 pm
It is working fine.
but one doubt If we want to highlight the jobname @job near @msg is it possible to do that?
December 2, 2015 at 10:21 am
Hi,
Thanks. It is working some what. Here now I am getting two emails with the same msg. If I removed @body nothing is coming just email with sub is...
December 2, 2015 at 10:08 am
If you have 10 records for that job so far, 7 times ran in 2.5 hrs one run 3 hrs, another run 5 hr another run 6 hr, I think...
November 25, 2015 at 3:06 pm
I tried the following script but it is not working properly. It is sending just plain attachment no result
Ue [Tools]
CREATE PROCEDURE [dbo].[Sp_JObStatus](@JobName SysName)
As
select job.Originating_Server Server
,job.Name JobName...
November 24, 2015 at 1:00 pm
It is seperating with comma but I am looking something like as in the excel.
I attached my query results. If we see the image the columns 2(stepId), 3 (stepname) results...
November 19, 2015 at 4:04 pm
Yes you are right.
I changed the single quotes still it is failing at the same place.
Changed from 'Failed' to [Failed]
November 19, 2015 at 3:22 pm
With view it is working.
The format is not in a proper way. I need help in formatting.
I have 5 columns in select list but the jobname, stepid, stepname is...
November 19, 2015 at 12:38 pm
I need same format as Anthony provided but without CTE because I already have several sub queries in my main query
November 19, 2015 at 9:45 am
Hi,
Thanks for the reply.
I use
dateadd(hour, (run_time / 1000000) % 100,
dateadd(minute, (run_time / 10000) % 100,
...
November 19, 2015 at 9:42 am
Viewing 15 posts - 181 through 195 (of 628 total)