Does this help?

https://www.sqlservercentral.com/forums/topic/how-to-find-dts-package-name-from-job-step#:~:text=extract%20your%20DTSRUNDESC.exe%20file,the%20Package%20name%2C%20server%20Name.

Congrats, Paul. I'll reach out to see if anyone is interested.

I had 65 minutes yesterday in Houston. A 35 minute delay in Denver had me running through the airport to make a flight in another terminal before the doors closed....

Serverless is great, because it can autoscale, so you can say 4-8 CPUs rather than provisioning 4 or 8. However, if it turns off, you need good retry logic. The...

I logged in and saw the league just fine this week

I haven't seen a server come back because of thread exhaustion, but that may have been the business (or my own) lack of patience to wait and more willing to...

About a 3 hour delay Fri for me, mostly due to a slow flight getting to Austin to take me home.

Yesterday, no real delays for UAL in Denver related.

I think...

Same, but I suspect most political stuff is driven by money for a few people (the top 5%, big companies, politicians of all kinds), so they don't want to press...

Can you build a DSN That points here and connect? Something like: https://support.microsoft.com/en-us/office/administer-odbc-data-sources-b19f856b-5b9b-48c9-8b93-07484bfab5a7

I assume then you followed this: https://learn.microsoft.com/en-us/sql/relational-databases/polybase/polybase-configure-odbc-generic?view=sql-server-ver16

I'd say you need:

EXEC sp_msforeachdb  'use ? SELECT ''?'', definition FROM sys.all_sql_modules WHERE definition LIKE ''%xp_cmdshell%'';'
GO

USE msdb
GO
SELECT s2.job_id, s2.name, s.step_name FROM dbo.sysjobsteps AS s INNER JOIN...

• This reply was modified 1 year, 2 months ago by Steve Jones - SSC Editor.

Crazy, I was lightly worried Fri as I was traveling as well. No reported issues until we got to the airport (about 90 minutes before the flight) and got a...

I think the advice above is sound (sorry for the delay).

If you rewrite, I would look at a cloud based db, though mostly because of latency. If you stick close...

I tend to follow's Brian's methodology ^^

You haven't made this easy. The data you provided is in a text format for humans, not a format that makes it easy to load. We, or at least I,...

You don't seem to want to do work on your side. The data you provided isn't something I can easily run. It's just data.

I am happy to try and help,...