And since the file is linked, everything should run correctly. And let's go ahead and switch back to the automation and run it again. And yep, I have forgotten the where clause, so let me go ahead and add that right now.Īnd we're going to go ahead and set this to filter for black, and I will save. And I've exported more rows than I expected, so let me go ahead and move over to the demo file real quick. We have some null fields and that's because something's missing in this file. We can click on this link to actually open the file, and we can see our comma separated value file with the data. In the log window, if there are any errors, they would show up here, but we can see that it's run successfully because we have the done message, and we have executed the SQL, and exported the data into the CSV file. We will start by simply choosing run in the toolbar to execute the script. If you have not already done so, please open up your automation script. Now we will test and schedule that script. In part one, we opened an automation tab, created a simple script. It is assumed for this video that you have the SQL Server Management Studio plug-in installed, you have a database connection established in either SQL Server Management Studio or in Toad, and you have a SQL statement that you want to automate. In this video, we will cover the basics of automation. These are just a few of the Toad features that enhance productivity. Hello, my name is Robert Pound, and I'm a Quest technologist.
0 Comments
Leave a Reply. |