When I use xp_cmdshell to zip files or hash files on a server in a stored procedure with a nex following T-sql statement to write a datetime into a log table, is this datetime after the zip cmd or hash cmd has finished on the server (wait for reply), or is it just after sending the cmd's to the server (fire-and-forget)?
xp_cmdshell in sql server - fire-and-forget or wait-for-reply?
1.1k views Asked by Gideon At
1
There are 1 answers
Related Questions in CMD
- Set req query output to a variable
- 'No such file or directory' installing RTC-Tools through pip
- Merge all *csv and remove duplicate headers using command prompt except top row
- Trying to launch batch file from powershell, and immediately closes
- How to export CMD output to a text file in C# after all the text printing on the CMD window is done?
- 'pip install mariadb' states that it cannot find include file 'mysql.h' on my Windows 10 dekstop
- Python Console commands
- How use subprocess.run with cmd external program in phython
- How do I restart a batch file in PowerShell?
- execute cmd commands as admin with java code
- PostgreSQL 16 database will not run as service, must have a CMD open for it to work
- How can I unload Visual Studio projects via batch file/developer command prompt?
- Connect to a specific country using Psiphon vpn from Command line
- How do I run multiple instances of my Powershell function in parallel?
- cmd command through powershell fails with error "The string is missing the terminator: '."
Related Questions in XP-CMDSHELL
- Message through xp_cmdshell in SQL Server 2014
- How to export resultset of a procedure with parameters using T-SQL command in SQL Azure database
- When executing Python via xp_cmdshell, print does not return to the SQL Output
- Fail to pull Azure DevOps repository called by T-SQL
- TSQL query to delete all files in a directory using xp
- T-SQL exec master..xp_cmdshell sqlcmd command unable to include variable output path
- Using LIKE wildcard with % operator in SQL xp_cmdshell
- email a file from AWS S3 bucket to a user using sql
- 'Can't open file 'path': [Errno 2] No such file or directory' Error in SQL while using xp_cmdshell command
- Unavailable Shared Path using net use via xp_cmdshell
- Can't activate xp_cmdshell for one session only
- Mixed results running manage-bde from sql xp_cmdshell
- Running Python Scripts on Azure SQL Databases using Elastic Job Agent
- SQL Server - xp_cmdshell timeout
- Running xp_cmdshell in SQL Server to run python script. Xlwings portion throws 'Access is denied' error
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
xp_cmdshellwaits for the end of the executed command.Note "xp_cmdshell operates synchronously" from the documentation.
Note that this also makes sense in other ways, since you get the result of the executed command "Any output is returned as rows of text.".