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.
|