That article is for SQL 2008. The servers are 2017 and I'm pretty sure SMO code doesn't work anymore in 2017.

EDIT: Even looking at the PowerShell options, it doesn't...

easy with SMO

https://www.mssqltips.com/sqlservertip/3675/using-smo-with-powershell-to-obtain-sql-server-job-information/

you just need to create a list of servers to extract from and do a foreach loop on that list to call the job function.

use it all the time - and our DBA team has a central server with CMS setup so it is available to all DBA's (and some snr developers/architects) as well.

in...

for that you will need to have a audit log table and a trigger on the table you need to monitor- no other way to do it (other then perhaps...

• This reply was modified 1 year, 1 month ago by frederico_fonseca.

have a look at this https://www.sqlservercentral.com/forums/topic/sqlagentreaderrole-can-create-its-own-jobs-what-is-ms-thinking

SQLAgentReaderRole would be the role to use to allow them to view jobs - but as this gives also permissions to CREATE jobs a few...

not those settings (which should be changed in most occasions - just don't set it to automatic on newer version of SSIS)

look at https://learn.microsoft.com/en-us/sql/integration-services/data-flow/ole-db-destination?view=sql-server-ver16

setting can be applied on the execution of the script itself - changing global policy is bad - but changing to execute a internal script with the setting on is...

please do not create duplicate posts - you have already posted this (see https://www.sqlservercentral.com/forums/topic/updated-table-not-displaying-data) and you have gotten several replies - fact that they are not what you want (e.g....

get them properly formatted.

what you gave us is on a single straight line - so its unusable.

but I do have to say that if this is not giving you what...

likely you doing it incorrectly.

following works fine with SSMS 19.0.

2

where contents of the script is just a straight "gci c:\"

for true prod code I tend to avoid merge - performance vs insert/update can vary - either faster or slower and no quick rule to decide on it - its...

As the table is partitioned by a date - are records on "older" partitions ever updated/inserted/deleted? if not any index operation should be done on recent partitions only, which would...

look at this thread as it gives a good explanation - better to turn that setting off - https://stackoverflow.com/questions/59505490/ssis-2019-autoadjustbuffersize-causes-buffer-allocation-error

you did NOT give us the SQL code you are running - so nothing for us to advise on - just giving a table content and stating  you get no...

That script snippet seems to update the wrong job. The obfuscated name is larger than "DWLoad" for the job name in the job properties screenshot. Are you sure you...