Sql

Search

Run batch file from SQL

Do it like the picture: like this image. Attention:
https://stackoverflow.com/questions/54862309/run-batch-file-from-sql/71397512#71397512
The drive containing the batch file should be other than the C drive, to avoid trouble.
Add execute, read and write permissions for the user, which you are using to run the batch file, to get the username run this query: EXEC master..xp_cmdshell 'whoami', get the name after the  sign. , for example "nt servicemssqlserver", add permission for this user: mssqlserver
Finally make sure you put the batch file on the same server as where you execute your Job.

Comment

PREVIOUS	NEXT

Code Example
Sql :: SQL Copy Selected Columns Only
Sql :: sql script to get a type task on jira datbase for 12 months
Sql :: dump only data
Sql :: error database connection
Sql :: nodejs sql get one to many relationship as array
Sql :: ring SQLite sqlite_close
Sql :: convert xml data to table format sql server
Sql :: print orcale
Sql :: How to write triggers to increment or decrement the number of employees
Sql :: mysql select top 2
Sql :: postgres call view
Sql :: postgres docs /copy metacomand
Sql :: What is the difference between the LIKE and REGEXP operators in mysql?
Sql :: save_details_inrichting
Sql :: ORA-01400
Sql :: Xampp resolve mysql issue
Sql :: quantity count and group by some article
Sql :: how to make sure two tables have same exact data in sql
Sql :: tabular function in sql server
Sql :: strat with in sql
Sql :: sql server and spring boot api
Sql :: SQL Cut part string
Sql :: ring SQLite create a SQLite database, add new records then display the data
Sql :: insert data
Sql :: correlated subquery
Sql :: count with where
Sql :: delete duplicate data from table
Sql :: ssms keyboard shortcuts
Csharp :: unity next scene
Csharp :: split on uppercase c#

Search

SQL

Run batch file from SQL

ADD CONTENT