Wow.

Such a simplistic approach and the never-ending procedure completed in 7 minutes and 40 seconds. I added the MAXDOP and PAGLOCK, and reduced the batch size to 5000...

SELECT *,...

Sorry I didn't clarify a few things that obviously were important, so let me clarify 4 those things:

1) I dropped all non-clustered indexes but kept the clustered (which I just...

Got this working. A colleague forwarded me this article (http://www.dwdmbi.com/2010/12/use-updlock-readpast-table-hints-to.html) which made an interesting note about a needed index in order to avoid SQL parsing through the entire table...

Thanks for the suggestions...will try them out shortly.

I wanted to clarify this though, wouldn't:

SELECT TOP 1 (...) FROM Reports WITH(UPDLOCK, READPAST) or (ROWLOCK,READPAST)

lock the row from the Reports table...

Thanks for the input guys, I've asked our Tech Services department to investigate the issue further.

@Dixie

Absolutely! Some great pubs here in Nashville!

No worries Jeff. I value your comments and a lot of times look to see your answers on others posts because you've always got something good to say! ...

Jeff, see the very first post

This was the code that I originally posted. Pretty simplistic. Later when you requested me not to paraphrase anything (which I don't get...

Good God Jeff. Of course there's TRY...CATCH blocks all over the code above. After all. THATS what I originally posted. There's no conspiracy here. And yes,...

Actual code (really not much different that already posted regards what I'm trying to accomplish but here it is:

DECLARE @Cnt int

DECLARE @job_id uniqueidentifier

DECLARE @job_1 varchar(100), @job_2 varchar(100), @job_3 varchar(100),...

Appreciate the input guys (sincerely) and it's immensely VALUED but this still doesn't resolve the error at hand:

Msg 22022, Level 16, State 1, Line 0

SQLServerAgent Error: Request to run job...

It would all seem to be a matter of "timing". Yes I did set a delay (1 hour) but I guess I didn't wait enough...when I checked it again...

Thanks for the post! To clarify: I know how to restore a DB in either state :), my muddled question was if anyone knew why it might not be...

Try Ninja's suggestion and run it against the linked server itself, and you can also try it using OPENQUERY

For instance:

SELECT

DISTINCT pt.ptno,t.suspense

FROM OPENQUERY(lnksvr1, '

SELECT pt.ptno,t.suspense

FROM

db1.dbo.Table1 pt

INNER JOIN db1.dbo.[271_Ineligible]...

Try this link 😎

It's helpful for what you are needing and will provide a little humor for the day!