CMD SQL TEST -> SQL VESRION

JanSrp / command

CMD,SQL

1 stars 0 forks source link

CMD SQL TEST -> SQL VESRION #25

Open JanSrp opened 1 year ago

JanSrp commented 1 year ago

1.Zapnout CMD as ADMIN

sqlcmd -S MSSQLKTA -Q "SELECT @@VERSION AS 'SQL Server Version';"

-S název serveru

JanSrp commented 1 year ago

Suspend JOBS

sqlcmd -S MSSQLKTA -Q " use TEST_KofaxTotalAgility SELECT JOB_ID, [CREATION_TIME], [STATUS] = 'Suspended',[PROCESS_NAME], [VERSION], [STATE], [SUSPEND_REASON], [LAST_MODIFIED_DATE] FROM [JOB] Where JOB_STATUS = 3 Order By PROCESS_NAME desc"