Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. johnpayback

    Multiple Arrays written to text file

    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...
  2. johnpayback

    ksh cannot open .sql file using Autosys job

    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...
  3. johnpayback

    korn shell with sqlplus and sqlldr

    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...
  4. johnpayback

    sqlplus and sqlldr in same ksh script

    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...
  5. johnpayback

    Remote Forced Reboot

    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...
  6. johnpayback

    Keep TCP/UDP port open/alive

    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...
  7. johnpayback

    SQL move text from one field to another

    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...
  8. johnpayback

    Moving text fields to other text fields

    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
  9. johnpayback

    Check for wscript running on multiple servers

    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...
  10. johnpayback

    Parse SQL field for specific number

    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...
  11. johnpayback

    Windows Service running a VBS file

    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...
  12. johnpayback

    Scripts to use with GFI

    Does anyone know of any good scripts that are for using with GFI's monitoring software? JP
  13. johnpayback

    Web Part for GFI

    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
  14. johnpayback

    Date/Time not displaying seconds

    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...
  15. johnpayback

    SQL with loop for each of the last 365 days

    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...
  16. johnpayback

    Run package for each of the last 365 days

    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...
  17. johnpayback

    Search Text Files for Multiple Keywords

    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...
  18. johnpayback

    Run EXE without using MSTask

    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...
  19. johnpayback

    Shell Command StdOut

    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
  20. johnpayback

    Progress Bar - thread329-898604

    Does anyone know how to make this progress bar script work with IE 7? JP

Part and Inventory Search

Back
Top