19 lines
532 B
Markdown
19 lines
532 B
Markdown
# Monthly SQL Query automation
|
|
|
|
## Description
|
|
You can set the DB server and database in the config part of the script.
|
|
You can specify settings:
|
|
```
|
|
$SQLServer = "dbserver1"
|
|
$SQLDBName = "database"
|
|
$delimiter = ";"
|
|
```
|
|
|
|
The SQL files queried for are:
|
|
```
|
|
$SqlFile = 'Query file 1'
|
|
$SqlFile = 'Query file 2'
|
|
$SqlFile = 'Query file 3'
|
|
```
|
|
These SqlFiles corespond to ea. "Query file 1.sql" and will be output to 'YYYYMMDD/Query File 1.csv'
|
|
The script uses your windows credentials to log in to the server and execute the queries. |