Avatar of Jo Cox
Jo CoxFlag for United Kingdom of Great Britain and Northern Ireland

asked on 

Power shell events and SQL

Hi Experts

Can I use powershell to set an event, in this case monitor a directory for a file to be created then spawn some SQL that will take the contents of the file as a parameter?

Jo
PowershellWindows 10AzureWindows Server 2016SQL

Avatar of undefined
Last Comment
Jo Cox
ASKER CERTIFIED SOLUTION
Avatar of oBdA
oBdA

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Jo Cox
Jo Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

This looks really useful, thank you.
What do you think would be the best way to approach registering something like this as a service.
Avatar of oBdA
oBdA

Either as a scheduled task, with a trigger of System Startup, or this:
NSSM - the Non-Sucking Service Manager
https://nssm.cc/
Avatar of Jo Cox
Jo Cox
Flag of United Kingdom of Great Britain and Northern Ireland image

ASKER

Many Thanks, gives me a good starting place to work from.
SQL
SQL

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.

61K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo