Mixing
Disconnecting OpenFiles
I've been researching and learning about windows batch files, PowerShell and cmd these past few days.
We're having issues with Open Files, so we manually go to the server and do it with a press of a button. But since there might be a possible way to automate it and do the script every 5 minutes.
Someone helped me already telling me that I should make a script of
openfiles /disconnect /a* /op "E:SERVERNAME"
& so I did and put it on the Windows Task Scheduler Action Tab - Start a Program and put the file path of the batch file that I made.
But It seems that it's not working and we're still having the same issue.
I hope I made it clear.
powershell batch-file automation taskscheduler
edited Nov 20 '18 at 0:47
Drew
1,170416
asked Nov 20 '18 at 0:39
CK9CK9
62
add a comment |
I've been researching and learning about windows batch files, PowerShell and cmd these past few days.
We're having issues with Open Files, so we manually go to the server and do it with a press of a button. But since there might be a possible way to automate it and do the script every 5 minutes.
Someone helped me already telling me that I should make a script of
openfiles /disconnect /a* /op "E:SERVERNAME"
& so I did and put it on the Windows Task Scheduler Action Tab - Start a Program and put the file path of the batch file that I made.
But It seems that it's not working and we're still having the same issue.
I hope I made it clear.
powershell batch-file automation taskscheduler
edited Nov 20 '18 at 0:47
Drew
1,170416
asked Nov 20 '18 at 0:39
CK9CK9
62
2
You do realize that this is likely to cause data loss due to unsaved changes, don't you?
– Ansgar Wiechers
Nov 20 '18 at 0:49
So what's the best way to do if the file is locked but we already saved and closed it? so the other won't be affected by it especially the ones that some people are still handling.
– CK9
Nov 20 '18 at 1:09
2
If it's saved and closed, why would it be open?
– SomethingDark
Nov 20 '18 at 3:21
The best way is to find the source of the locking. Most likely the application that is creating a FileStream (aka writing to the file) isn't properly disposing of it's resources. If this is a .NET application that would mean there is a missing using statement.
– P.Brian.Mackey
Nov 20 '18 at 3:55
If it's powershell that's writing to the file then callingDispose()should do it. Also see stackoverflow.com/questions/14294055/…
– P.Brian.Mackey
Nov 20 '18 at 3:58
add a comment |
I've been researching and learning about windows batch files, PowerShell and cmd these past few days.
We're having issues with Open Files, so we manually go to the server and do it with a press of a button. But since there might be a possible way to automate it and do the script every 5 minutes.
Someone helped me already telling me that I should make a script of
openfiles /disconnect /a* /op "E:SERVERNAME"
& so I did and put it on the Windows Task Scheduler Action Tab - Start a Program and put the file path of the batch file that I made.
But It seems that it's not working and we're still having the same issue.
I hope I made it clear.
powershell batch-file automation taskscheduler
edited Nov 20 '18 at 0:47
Drew
1,170416
asked Nov 20 '18 at 0:39
CK9CK9
62
I've been researching and learning about windows batch files, PowerShell and cmd these past few days.
We're having issues with Open Files, so we manually go to the server and do it with a press of a button. But since there might be a possible way to automate it and do the script every 5 minutes.
Someone helped me already telling me that I should make a script of
openfiles /disconnect /a* /op "E:SERVERNAME"
& so I did and put it on the Windows Task Scheduler Action Tab - Start a Program and put the file path of the batch file that I made.
But It seems that it's not working and we're still having the same issue.
I hope I made it clear.
powershell batch-file automation taskscheduler
powershell batch-file automation taskscheduler
edited Nov 20 '18 at 0:47
Drew
1,170416
asked Nov 20 '18 at 0:39
CK9CK9
62
edited Nov 20 '18 at 0:47
Drew
1,170416
asked Nov 20 '18 at 0:39
CK9CK9
62
edited Nov 20 '18 at 0:47
Drew
1,170416
edited Nov 20 '18 at 0:47
Drew
1,170416
edited Nov 20 '18 at 0:47
Drew
1,170416
1,170416
asked Nov 20 '18 at 0:39
CK9CK9
62
asked Nov 20 '18 at 0:39
CK9CK9
62
asked Nov 20 '18 at 0:39
CK9CK9
62
62
2
You do realize that this is likely to cause data loss due to unsaved changes, don't you?
– Ansgar Wiechers
Nov 20 '18 at 0:49
So what's the best way to do if the file is locked but we already saved and closed it? so the other won't be affected by it especially the ones that some people are still handling.
– CK9
Nov 20 '18 at 1:09
2
If it's saved and closed, why would it be open?
– SomethingDark
Nov 20 '18 at 3:21
The best way is to find the source of the locking. Most likely the application that is creating a FileStream (aka writing to the file) isn't properly disposing of it's resources. If this is a .NET application that would mean there is a missing using statement.
– P.Brian.Mackey
Nov 20 '18 at 3:55
If it's powershell that's writing to the file then callingDispose()should do it. Also see stackoverflow.com/questions/14294055/…
– P.Brian.Mackey
Nov 20 '18 at 3:58
add a comment |
2
You do realize that this is likely to cause data loss due to unsaved changes, don't you?
– Ansgar Wiechers
Nov 20 '18 at 0:49
So what's the best way to do if the file is locked but we already saved and closed it? so the other won't be affected by it especially the ones that some people are still handling.
– CK9
Nov 20 '18 at 1:09
2
If it's saved and closed, why would it be open?
– SomethingDark
Nov 20 '18 at 3:21
The best way is to find the source of the locking. Most likely the application that is creating a FileStream (aka writing to the file) isn't properly disposing of it's resources. If this is a .NET application that would mean there is a missing using statement.
– P.Brian.Mackey
Nov 20 '18 at 3:55
If it's powershell that's writing to the file then callingDispose()should do it. Also see stackoverflow.com/questions/14294055/…
– P.Brian.Mackey
Nov 20 '18 at 3:58
2
2
You do realize that this is likely to cause data loss due to unsaved changes, don't you?
– Ansgar Wiechers
Nov 20 '18 at 0:49
You do realize that this is likely to cause data loss due to unsaved changes, don't you?
– Ansgar Wiechers
Nov 20 '18 at 0:49
So what's the best way to do if the file is locked but we already saved and closed it? so the other won't be affected by it especially the ones that some people are still handling.
– CK9
Nov 20 '18 at 1:09
So what's the best way to do if the file is locked but we already saved and closed it? so the other won't be affected by it especially the ones that some people are still handling.
– CK9
Nov 20 '18 at 1:09
2
2
If it's saved and closed, why would it be open?
– SomethingDark
Nov 20 '18 at 3:21
If it's saved and closed, why would it be open?
– SomethingDark
Nov 20 '18 at 3:21
The best way is to find the source of the locking. Most likely the application that is creating a FileStream (aka writing to the file) isn't properly disposing of it's resources. If this is a .NET application that would mean there is a missing using statement.
– P.Brian.Mackey
Nov 20 '18 at 3:55
The best way is to find the source of the locking. Most likely the application that is creating a FileStream (aka writing to the file) isn't properly disposing of it's resources. If this is a .NET application that would mean there is a missing using statement.
– P.Brian.Mackey
Nov 20 '18 at 3:55
If it's powershell that's writing to the file then calling
Dispose() should do it. Also see stackoverflow.com/questions/14294055/…– P.Brian.Mackey
Nov 20 '18 at 3:58
If it's powershell that's writing to the file then calling
Dispose() should do it. Also see stackoverflow.com/questions/14294055/…– P.Brian.Mackey
Nov 20 '18 at 3:58
add a comment |
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53384632%2fdisconnecting-openfiles%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53384632%2fdisconnecting-openfiles%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
2
You do realize that this is likely to cause data loss due to unsaved changes, don't you?
– Ansgar Wiechers
Nov 20 '18 at 0:49
So what's the best way to do if the file is locked but we already saved and closed it? so the other won't be affected by it especially the ones that some people are still handling.
– CK9
Nov 20 '18 at 1:09
2
If it's saved and closed, why would it be open?
– SomethingDark
Nov 20 '18 at 3:21
The best way is to find the source of the locking. Most likely the application that is creating a FileStream (aka writing to the file) isn't properly disposing of it's resources. If this is a .NET application that would mean there is a missing using statement.
– P.Brian.Mackey
Nov 20 '18 at 3:55
If it's powershell that's writing to the file then calling
Dispose()should do it. Also see stackoverflow.com/questions/14294055/…– P.Brian.Mackey
Nov 20 '18 at 3:58