The database query action can be used With this circumstance to query the PolicyInstances desk to discover if a particular runbook is currently running.
We'll now increase the runbook activity that may run the SQL Server setup itself, go to the ideal beneath Technique
We will commence by locating the installation data files, Allow’s head into the folder the place we downloaded the Orchestrator 1807 installation documents.
When I to start with set up the Orchestrator beta I had SQL server and all Orchestrator components on exactly the same device, but not surprisingly right after a couple of days I required to go the database to some focused SQL server.
Finally we may even configure this runbook action, to run on a unique area account, go to Security around the left from the
The re-set up took a few minutes. I guess there is a configuration file we could edit far too, but re-installation is a quick and easy Alternative.
This is often completed by pointing to the roles selection, but in addition expanding the runbook selection also to grab it’s involved info. Then you can use the filter and select statements in the odata question to filter to the title in the runbook.
Now select a location where by the Orchestrator 1801 set up files will probably be extracted, simply click Upcoming to continue.
For the supported variations of SQL, utilize the company packs that are currently in support by Microsoft.
Here is the whole script to question the web service (fields in red would need to be updated per your environment):
Enter a site account which includes permissions to conduct the jobs stated earlier mentioned, the moment we have been accomplished, click Complete.
Since our SQL Server is up and functioning, we can go forward to the following action by setting up Orchestrator SCORCH Database Migration 1801.
We should always now see all available info that can be fetched in the Initialize Facts activity. Which means we can get the Server Name and use it in all the other runbook activities in our runbook.
Following the set up is finish you might want to modify the "tnsnames.ora" (In my circumstance I created a brand new file and named it as tnsnames.ora) Enter the small print in the