FTP a file on Hourly basis Post: 302526006

9 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

How do you automate an hourly file check?

Hi, New to the forum, Great site, I can learn a lot from here!! :cool: I would like to know how to automate a command that checks the Sybase database's are "alive" on an hourly basis, and mails outlook if they are not

2. UNIX for Dummies Questions & Answers

count string occurance in a file hourly

Hi, I file that has all the status for one day (24hours). Now what I want to do is to count the occurence of a string in its output hourly like for example count occurance of successful or asynchronous clear destinon for every hour and redirect it to file. Please see sample file below. Please...

3. Solaris

Monitoring the output of 'top' command on hourly basis.

I need to capture the following data on an hourly basis through cronjob scheduling:- 1. load averages 2. Total no. of processes. 3. CPU state 4. Memory 5. Top 3 process details. All the above information is available through the command 'top'. But here we need to automate the same and...

4. Shell Programming and Scripting

Increment #'s in text file hourly

I have a text file with a number "001". I am trying to change this number every hour and increment by "1". So every hour it would add +1 to that number. I am able to change the file with sed but unable to have it increment it by "1" without me adding that to the sed command. Any help is...

5. Shell Programming and Scripting

how to grep string from hourly basis files

dear all, pls help on this script.. i have many files which will be created every mins in particular directory. i want to grep a particular string from only for unique hour files. from the below code i want to grep a string from only 9th hour files . Ex files: -rw-r--r-- 1 root ...

6. Shell Programming and Scripting

Create log file periodically ex: hourly

Hello, I have a command which runs continuously and creates output to STDOUT. Now, in unix, if I create logging for this command, it would create a single log file and keep on updating. As there is so much data filled in it, I would want to break the log files periodically. In this instance, say...

7. Shell Programming and Scripting

Crontab on hourly basis

Hi.. I need to run the script on hourly basis. How do I write the crontab on hourly basis i.e, 9:00, 10:00.....22:00.. 23:00 hours Please let me know if the below is correct one for crontab on hourly basis. 00 * * * * ksh myscript.ksh > /dev/null Regards, John

8. Shell Programming and Scripting

Calculate avg response time on hourly basis

Hi, I am trying to calculate avg response time on hourly basis from the log file which has millions of records. As of now I am trying with creating temp file which will have lines with unique id and start time and end time and after that another script will run on this temp file to...

9. Shell Programming and Scripting

Combining files(every 15 min) as one file(hourly)

Hello, My system is generating two files every 15 minutes and file names are given automatically as below. (98,99,89,90 are the sequence numbers) File1_09242013131016_000000098 File1_09242013131516_000000099 File2_09242013124212_000000089 File2_09242013124712_000000090 I want to combine...

LEARN ABOUT DEBIAN

osql

osql(1) 							 FreeTDS Utilities							   osql(1)

NAME

       osql - utility to test FreeTDS connections and queries

SYNOPSIS

       osql  -S dsn -U username -P password [-I ini_dir]

DESCRIPTION

       osql  is a diagnostic tool provided as part of FreeTDS. It is a Bourne shell script that checks and reports on your configuration files. If
       everything checks out OK, it invokes isql.

       osql works only with the isql that comes with unixODBC.

OPTIONS

       -S dsn the Data Source Name to which to connect, as known to odbc.ini.

       -U username
	      database login name.

       -P password
	      database password.

       -I ini_dir
	      override odbc.ini file location.

EXAMPLE

       If you have an odbc.ini with a section like this:

	       [myDSN]
		       servername = myserver
		       TDS_Version = 5.0

       You would invoke osql as:

	       osql -S myDSN [...]

NOTES

       If you can connect with "osql -S servername -U user -P passwd", your FreeTDS ODBC installation is working.

       osql guesses where unixODBC might look for its odbc.ini by examining the binary. This is not always an effective approach.  If  it  doesn't
       work, you'll receive a report of candidate strings. Kindly pass along the output to help improve the guessing.

       If  osql  cannot intuit your odbc.ini directory, you can force the issue with the -I option. However, you're instructing osql what to test,
       not where unixODBC will eventually look. Your override is therefore only as good as you are. Look carefully  at	the  error  output  before
       overriding.

       If you have suggestions for ways to make osql more useful as a diagnostic tool, please post them to the FreeTDS mailing list.

HISTORY

       osql first appeared in FreeTDS 0.65.

AUTHORS

       The osql utility was written by James K. Lowden

doc								 13 November 2011							   osql(1)