Sky

Brandie Tarvin (7/22/2016)

---

jasona.work (7/22/2016)

---

Brandie Tarvin (7/22/2016)

---

Oh, now this is funny.

My SO's ex-boss still stays in contact with him. I've met her a few times.

Today she emails the SO. Apparently UX...

Range

Michael L John (7/21/2016)

---

Jeff Moden (7/21/2016)

---

Probably a group effort by the folks at Brent Ozar Unlimited, since it's posted...

It's good to review things like this once in a while. Thanks for a good question.

Skeet

rk1980factor (7/21/2016)

---

i think below query might work but it shows the full history. I just want to see job name and last run date/time and duration

SELECT h.server, j.name, h.run_date, h.run_time,...

Yes, you have to replace the job name "your job name" with...

You didn't drop a nonclustered index between query 2 and query 3, did you?

Are they run on the same server against the same table and database?

I'm asking because those are...

So this is basically a query of job history. Something along these lines should get you started.

SELECT h.server, j.name, h.run_date, h.run_time, h.run_duration

FROM msdb.dbo.sysjobs j

...

rk1980factor (7/21/2016)

---

So i have several queries which give me the list of job information for each database names.

I do not want to see db name column

I am looking for query...

Humility

Eirikur Eiriksson (7/21/2016)

---

Done this or similar to this since 4.2, haven't forgotten...

Eirikur Eiriksson (7/21/2016)

---

Good stuff! Here is a quick example which should get you passed this hurdle

😎

USE TEEST;

GO

SET NOCOUNT ON;

--

IF OBJECT_ID(N'dbo.request_log') IS NOT NULL DROP TABLE dbo.request_log;

CREATE TABLE dbo.request_log(

[id] [int] IDENTITY(1,1)...

Nice question with a very good explanation.