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...

Hello,

I am seeing the same issue. I checked the database configuration and it seems OK, but perhaps someone else can post more info on why this happens and how to...

Thanks, Frederico. This was indeed ultimately a permissions issue.

-- webrunner

Hello,

You can also run the query here for a general sense of what SQL Server is waiting on:

SQL Server Wait Statistics (or please tell me where it hurts…)

https://www.sqlskills.com/blogs/paul/wait-statistics-or-please-tell-me-where-it-hurts/

HTH.

--...

"I walked outside to take the call during a break and was told I wasn't responding quick enough to the call. The emergency? A test of how quickly I'd respond...

• This reply was modified 2 years, 1 month ago by  webrunner.

Jeff, at the risk of introducing more adages into this thread, your most recent reply reminds me of another I heard once: "If you don't have time to do it...