again you keep failing to address how to ask for help here - and again you fail to understand that on this case only you can see what is wrong...

dup post - see replies on https://www.sqlservercentral.com/forums/topic/destination-table-condition-amount-0-3

• This reply was modified 6 months, 2 weeks ago by  frederico_fonseca.

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 6 months, 3 weeks 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...

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

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