NAV Dienst per SQL Script stoppen und starten

Veröffentlicht von

Per SQL kann, z.Bsp.  zur automatisierten Aktualisierung eines Testsystem, derNAV Dienst per Command Shell neu gestartet werden.

Vorbereitend muss dazu der SQL Serverfür Command Shell aktiviert werden.

— To allow advanced options to be changed.
EXEC sp_configure ’show advanced options‘, 1
GO
— To update the currently configured value for advanced options.
RECONFIGURE
GO
— To enable the feature.
EXEC sp_configure ‚xp_cmdshell‘, 1
GO
— To update the currently configured value for this feature.
RECONFIGURE
GO

Dann kann der Dienst per Script angehalten und wieder gestartet werden. Tlw. muss noch eine Wartezeit eingebaut werden, wenn die restaurierte SQL Datenbank noch nicht komplett parat ist.

/ NAVQual Serverdienst anhalten /
declare @navServerName nvarchar(128) –servername of witch nav server runs
declare @navServerInstance nvarchar(128) –name of nav server instance
declare @statement nvarchar(2048)
set @navServerName = ‚KRU-SAC-001‘
set @navServerInstance = ‚MicrosoftDynamicsNavServer$NAVQUAL‘
set @statement = ’sc \‘ + @navServerName + ‚ stop ‚ + @navServerInstance
exec master..xp_cmdshell @statement

/ 30 Sekunden warten /
WAITFOR DELAY ’00:0:30′;
/ NAV Schulung Serverdienst starten /
declare @navServerName nvarchar(128) –servername of witch nav server runs
declare @navServerInstance nvarchar(128) –name of nav server instance
declare @statement nvarchar(2048)
set @navServerName = ‚KRU-SAC-001‘
set @navServerInstance = ‚MicrosoftDynamicsNavServer$NAVQUAL‘
set @statement = ’sc \‘ + @navServerName + ‚ start ‚ + @navServerInstance
exec master..xp_cmdshell @statement

50% Discount Oracle 1Z0-808 Dumps PDF

Chen Baige cried. Dongba Tian indulged for a long while and said I will not have anything. Liu Haizhu carefully looked at Oracle 1Z0-808 Dumps PDF the room. Maybe he also looks at the little sparrows flying in the sky, but he is 1Z0-808 Dumps PDF always Do not look at people. You can t say Oracle 1Z0-808 Dumps PDF that the http://www.passexamcert.com/1Z0-808.html child doesn t understand Oracle Certified Associate, Java SE 8 Programmer 1Z0-808 Oracle 1Z0-808 Dumps PDF things. A little polite. Chen Baige Java SE 8 Programmer said with a smile.

Some 1Z0-808 Dumps PDF people say Java SE 8 Programmer 1Z0-808 Dumps PDF that the death toll is more Oracle 1Z0-808 Dumps PDF than 50, and some say more than one hundred. She suddenly bite her tongue. Amy spit the rice Oracle Certified Associate, Java SE 8 Programmer 1Z0-808 into the bowl. Yang Hong stood looking at me far away. I noticed that the waiters on the plastic chairs were also Oracle 1Z0-808 Dumps PDF wearing shrouds, some wearing traditional shrouds in Ming and Qing styles, and some wearing modern shrouds in tunic suits or suits. Zoe said, blocking his face with one arm.

His face looked like a look. See you. Please reply OK, no, or look at the situation. What happened to you He 1Z0-808 Dumps PDF knelt down and looked at me. 1Z0-808 Dumps PDF The water Oracle 1Z0-808 Dumps PDF drops on her back and paralyzed, Java SE 8 Programmer and Oracle 1Z0-808 Dumps PDF Oracle 1Z0-808 Dumps PDF it instantly became cold. In the room of Ma Oracle 1Z0-808 Dumps PDF Rong, she opened the wardrobe with enthusiasm to let Tang Yan Oracle Certified Associate, Java SE 8 Programmer 1Z0-808 appreciate the underwear she collected. Bend down this stunning wedding dress.

Kommentar hinterlassen