My typical experience as well working with...

Not sure what you are really asking. You can establish how many previous logs you wish to retain. The default is 6 log files including the current, iirc.

Please post all the code you are using.

Did you also make the change Robin suggested?

If so, and it still didn't work, what error message(s) do you get.

Some of it depends on the query itself in Access. If you are joining a SQL table to an Access table, hope the table in SQL is small as...

Now, show us what you have done so far in an attempt to solve your problem.

The only other thing I would recommend, take the spaces out of your filename. Spaces in the names of directories and files just cause problems with automated processes. ...

Robin Sasson (5/1/2012)

---

Hi Lynn,

I can't remember where I got hold of this script but it does the conversion as you've asked:

SELECT J.[name] ...

Yes, yes...

If what time, the integer value represents the time the job or job step started in the format hhmmss.

dwilliscp (5/1/2012)

---

In the MSDB MS is storing the information about a SQL Job, and in the DBO.SysJobHistory it has a column called "run_time".. Using SQL how do you convert this...

jmadsen 98862 (5/1/2012)

---

This seems like a good time to point something out I've thought about.

It is quite disappointing that SQL ServerCentral continues to leave Mr. Celko's comments on this...

I am glad my very simplistic example helped. We are here if you have any questions.

iBar (4/30/2012)

---

..."@drew.allen": Please note that I have created this dataset and question for better clarity and keeping in view all my future aspects. So I am expecting answer based on...

Cursors serve a roll, but a very small one. Doing things in a set-based manner works faster as that is how SQL Server is built.

For a simplistic approach, think...