SQL Server Agent Job mit Batch ausführen
sqlcmd.exe -U batch_job_start -P batch_job_start -S DBM-MS-CRM.dbk.localMSCRM -Q “execute msdb.dbo.sp_sp_start_job_wait @job_name = ‘CRM Aktualisierung’”
This author has not written his bio yet.
But we are proud to say that AZConAdmin contributed 60 entries already.
sqlcmd.exe -U batch_job_start -P batch_job_start -S DBM-MS-CRM.dbk.localMSCRM -Q “execute msdb.dbo.sp_sp_start_job_wait @job_name = ‘CRM Aktualisierung’”
forfiles -p “C:ExporteCognosDonBoscoMission” -s -m *.pdf -d -30 -c “cmd /c del @PATH” forfiles -p “C:ExporteCognosDonBoscoMission” -s -m *.xml -d -30 -c “cmd /c del @PATH” forfiles -p “C:ExporteCognosDonBoscoMission” -s -m *.mht -d -30 -c “cmd /c del @PATH”
del “D:DBV DatenAZNTransfer*.txt” xcopy \Dbm-svssvsImportAZNKunden_Verlag_*.txt “D:DBV DatenAZNTransfer” xcopy \Dbm-svssvsImportAZNTest.txt “D:DBV DatenAZNTransfer”
ren “E:TM1 ApplicationsHallo.txt” Tag.txt
SELECT –DB_ID(‘Live_Staging’) DB_NAME(database_id) ,* –SELECT stats.index_id as id, name, avg_fragmentation_in_percent FROM sys.dm_db_index_physical_stats (DB_ID(N’Live_DWH ‘), NULL, NULL, NULL, NULL) AS stats JOIN sys.indexes AS indx ON stats.object_id = indx.object_id AND stats.index_id = indx.index_id AND name IS NOT NULL where database_id =6 –where name = ‘idx_customerCredit_customer_endamount’ –where name = […]
Einstellungen -> Datenschutz, Suche und Dienste -> Browserdaten löschen -> Zu löschende Elemente auswählen -> Zeitbereich bitte auf ‚gesamxte Zeit‘ -> Haken gesetzt bei ‚Cookies und andere Website Daten‘ und ‚Zwischengespeicherte Bilder und Dateien‘ Dann -> Jetzt löschen
SET TEXTSIZE 0; — Create variables for the character string and for the current — position in the string. DECLARE @position INT, @string CHAR(8); — Initialize the current position and the string variables. SET @position = 1; SET @string = ‘New Moon’; WHILE @position <= DATALENGTH(@string) BEGIN SELECT ASCII(SUBSTRING(@string, @position, 1)), CHAR(ASCII(SUBSTRING(@string, @position, 1))) SET […]
select REPLACE(ShipAddr,””,‘”‘), case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.Line1’) else NULL end asLine1, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.Line2’) else NULL end asLine2, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.City’) else NULL end as City, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.Country’) else NULL end asCountry, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.CountrySubDivisionCode’)else NULL end as CountrySubDivisionCode, case when ISJSON(REPLACE(ShipAddr,””,‘”‘)) = 1 then JSON_VALUE(REPLACE(ShipAddr,””,‘”‘), ‘$.PostalCode’) else NULL endas PostalCode from PY_Invoice
gekoppelt an die Application bei z.B. “Save”. (läuft bei STEG) auch ausführen von externen Xstream Jobs möglich. prolog: EXECUTECOMMAND(‘xstreamCLI /execute “TM1 W Umlagekonfiguration anwenden”‘, 1);
EXECUTECOMMAND(‘xstreamCLI /execute “TM1 W Umlagekonfiguration anwenden”‘, 1); — läuft aktuell bei STEG via TM1.