WayneS (11/19/2010)

---

LutzM (11/19/2010)

---

I hope you folks in the U.S. will have the following Friday as well as the weekend off and you'll have a wonderful weekend with your friends and...

Now you should see an entry in view history. What's the status (failed or success, and if failed, what message?)

Brings back memories... A huge turkey, so tender I can't forget, served...

Double click Job Activity Monitor in the Object Explorer pane.

What's the status of the job in question?

Try to assign an xls file name to @query_attachment_filename

like

@query_attachment_filename ='Test.xls'

IIRC, that's the way I did it when I needed the output in xls format.

If it doesn't work, post...

Do you get any error message? If so, which one?

And are you sure you really started the job?

Are there any steps inside the job?

Next step would be:

In Object Explorer: Right...

Do you get any error message? If so, which one?

Did you try to right-click at the job and view history to see if it ever started?

I'm glad the source of the performance drop has been identified. 😀

mnielsen-1015626 (11/19/2010)

---

Thank you Lutz, Ron, Mike, and Paul.

It was pretty cool to post a question at the end of day and come in the next day and see this type...

You could create a function that would perform a count on the table for rows with Status=0 and add this as constraint to your table.

Another option would be a INSTEAD...

marko61 (11/18/2010)

---

Thanks Leo

I appreciate that's how a cursor works (but given my original post thankyou for the explanatiion) and I've also seen a fair bit of advice saying don't use...

A post with nothing but the word "bump" in it.

Usually used to bring the post back on the "most recent" list.

It's...

BaldingLoopMan (11/18/2010)

---

My deepest apologies Jeff. I told someone he was as useful as a paraplegic mime in a past and that didn’t go over so well. So I was under...

Thank you for posting the solution you found.

Much better than a "never mind, I got it" reply, or, even worse, none at all... 😉

Dick Herberts-320552 (11/17/2010)

---

Hi guys,

I'am testing the routine right now on a table with 26.000.000 records, tomorrow i will give the performance results.

Thanks very much for all your knowledge input

Have a...