I believe I've gotten most of the code but I cannot figure out a way to get my text file formatted the way I would like it. Below is what I want my text file to look like.
Server Name Free Space
server1 24%
server2 34%
server3 87%
server4 73%
server5 75%
Here is my code so...
I have the script below which works via command line. When ran using Autosys it fails with the Autosys log saying "cannot open dialer_extract.sql". All files are in the same directory unless otherwise noted in the script.
What am I doing wrong and how do I fix it?
NOTE: I also tried adding the...
I am needing to call sqlplus and sqlldr in the same korn shell script. Below are the steps that I need to accomplish. I am new to Oracle shell scripting so an example would be great.
•CBOB_LOAD.KSH - script name
•Calls Oracle stored procedure sp_CBOB_CLEAR_LN_STAGING (SERVER: TESTSVR100)
•Calls...
I am needing to call sqlplus and sqlldr in the same korn shell script. Below are the steps that I need to accomplish. I am new to Oracle shell scripting so an example would be great.
•CBOB_LOAD.KSH - script name
•Calls Oracle stored procedure sp_CBOB_CLEAR_LN_STAGING (SERVER: TESTSVR100)
•Calls...
Hello...I currently have an issue forcing remote reboots. It seems that not all of my services/processes are shutting down and the server hangs with an error and doesn't reboot until the next time I login to it. Below is the code I threw together and I just use a .cmd file to execute it. The...
Would anyone happen to know how to keep a TCP/UDP port open or alive? I have an issue where my firewall will disable a port after 60 minutes if no traffic passes across it. The only way for me to reset it is to restart the application that uses the port. I wasn't sure Windows had any tools...
Is there an easy way to move specific contents of a text field to another text field? I have text fields in my table that contain comments for each month. At the end of the month I would like to move these contents to a different text field so that the original text field is empty.
I've posted...
Is there an easy way to move specific contents of a text field to another text field? I have text fields in my table that contain comments for each month. At the end of the month I would like to move these contents to a different text field so that the original text field is empty.
JP
Sorry to post again when I am still working on another post but I think this one should be easy. I need to write a script to check to see if wscript.exe is running on multiple servers. I would like to run the script from a central location and output the results to the screen. Would it be better...
I need to write a script that can give me the count of a number in a field on a MSSQL 2000 database. Below is the field. It contains more than just one piece of info.
This below is directly from one field in one table of my database. I need to count the occurrences of 20100 in each field like...
Does anyone know if it is possible on a Windows 2000 Server to create a Windows service so that it runs a VBS file instead of having to use an EXE? My problem is that I have a vbscript that runs continously but it cannot run unless an account is logged into the server. I need to make it run...
Can anyone tell me if there is a free web part for the GFI server monitoring software?
Also, is there a way to register a web part as safe without having access to the server? Possibly a way to do this through the web portal?
JP
I am running a query against a database that will generate a CSV report with the data. My problem is that the date/time fields that I'm querying are not adding the seconds into my report. The database does have the seconds in it so I'm baffled. Below is the script. What exactly am I doing wrong...
I need to have this statement pull the count for each day for the past 365 days. Currently it will pull the count every night for the previous day but I need it to pull the count for each of the past 365 days and insert them separately based on each day. I do not need to get the total count for...
I need to have this package pull the count for each day for the past 365 days. Currently it will pull the count every night for the previous day but I need it to pull the count for each of the past 365 days and insert them separately based on each day. I do not need to get the total count for...
I would like to know how I can search a text file with multiple keywords. I would like it to find lines in the text file that contain all of the keywords. So, an all or nothing. If you know how to make vbscript do this please let me know. An example would be great. I've been trying it using the...
I would like to be able to run desktop applications where they run as the name of the EXE such as an application called triggermanager.exe. I can't seem to figure it out. If I schedule it to run in task scheduler is runs as C:\WINNT\System32\MSTask.exe rather than what I want it to as...
I need to execute a grep command on a text file and display the output to an ASP file. I was not sure if I should ask in this forum or the ASP forum. How can I run a command and display it's results to the screen?
JP
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.