Hi Andy, Jonathan,

Thanks so much for your help. Sorry, just to clarify - I have not tested the AD login locally. That user doesn't have (i.e., is not allowed to...

One more thing I found: The SQL login works when I remote to the SQL host and log in locally. So it is something that happens for external connections.

Thanks again...

PS A little more info:

1. I was able to create a view with the same code but a slightly different name. Worked instantly.
2. Even trying to drop the original view...

• This reply was modified 2 years, 6 months ago by webrunner.

Hi Phil,

I checked, and the view definition does not include 'WITH SCHEMABINDING'. But thanks for this info - it will come in handy.

Next I am going to review the SQL...

Hi Jeffrey,

Great, thanks for your help. I'll check the logs to see what is different between the two subsets of databases that could be causing this issue.

-- webrunner

Hi Jo,

Thanks. To be honest, I have not tried much yet, as the connection is not making it to the SQL Server when this issue happens, so nothing is logged...

Note that packages are neither 32- nor 64-bit. But they can be run in 32- or 64-bit mode. A bit like Word really - a .docx is a .docx.

Thanks, I...

Thanks again, all.

I actually ended up doing nothing, and the next day the job history showed that the job succeeded at that scheduled time. And the previous, "In progress," entry...

Hi Ed,

The Job Activity Monitor says idle / succeeded.

I'll try your suggestions. Thanks!

-- webrunner

Hi Scott,

This is what I see:

-- webrunner

Thanks Ed,

I tried Refresh, and I even restarted SQL Server Agent. Still the same discrepancy.

-- webrunner

What do you mean "the job history says the job is running."  The jobhistory never shows that, it only show the past history.

Be sure to verify the instance_id.  If...

Hi Scott, thanks. I'll need to work with our systems team to track down any scanning that might be causing this issue.

Thanks again.

-- webrunner

Merry Christmas, Steve, thanks for that heartfelt and inspirational editorial.

And happy holidays to everyone else celebrating.

-- webrunner

Thanks Jeffrey, Frederico,

This information is very helpful. I will look into the audits as well as possibly trying to negotiate (unlikely but can't hurt to ask) with the Systems team...