You will need a 3rd party tool such as NetVault LiteSpeed for SQL Server or Redgate SQL Backup Pro.

You know I just realized that and I was going to edit my post.

Thank you!

Well thank you. That is nice but I'm looking for is the Start Datetime, End Datetime and elapsed time for each step for a single job.

I came up with something that works.

SELECT DISTINCT j.Name ...

Lynn Pettis (3/31/2013)

---

I can run the code all day long, it won't tell me what the problem is if you don't show me. I have no idea what the...

Lynn Pettis (3/31/2013)

---

Welsh Corgi (3/31/2013)

---

Welsh Corgi (3/31/2013)

---

Lynn Pettis (3/31/2013)

---

Perhaps something more like this:

SELECT

j.job_id,

s.srvname,

j.name,

js.step_id,

...

Welsh Corgi (3/31/2013)

---

Lynn Pettis (3/31/2013)

---

Perhaps something more like this:

SELECT

j.job_id,

s.srvname,

j.name,

js.step_id,

js.command,

...

Lynn Pettis (3/31/2013)

---

Perhaps something more like this:

SELECT

j.job_id,

s.srvname,

j.name,

js.step_id,

js.command,

...

Lynn Pettis (3/31/2013)

---

Welsh Corgi (3/31/2013)

---

Lynn Pettis (3/10/2013)

---

Welsh Corgi (3/10/2013)

---

Lynn Pettis (3/10/2013)

---

Since some of us do not necessarily have a similar environment as you, it may be helpful if you created...

Lynn Pettis (3/10/2013)

---

Welsh Corgi (3/10/2013)

---

Lynn Pettis (3/10/2013)

---

Since some of us do not necessarily have a similar environment as you, it may be helpful if you created temporary tables and populated...

Lynn Pettis (3/31/2013)

---

I can run the code all day long, it won't tell me what the problem is if you don't show me. I have no idea what the...

Try executing the query.

The code does not do what I intended.

I'm trying to format the LAST_RUN_Date and the END_RUN_TIME in the Job history table but I'm not cutting it.

I hoping to get the DateTime Formated correctly for the Start and...

Duplicate post. Do not reply.

http://www.sqlservercentral.com/Forums/Topic1435672-1550-1.aspx#bm1435678

Reinstalled Reporting Services but it retained the ReportingServices Configuration Files which prevented me from entering the Web Services URL.

Removing install and I will manually delete the WebSerives Files Directory and...