Hello there!
Maybe you could use a shell script in order to accomplish that task.
This is how I thought about it:
From 5 a.m to 7.am there are 2 hours, then 7200 seconds.
You want to run the
Code:
mysql
action every 5 seconds, then you need to run it 1440 times.
So, you could try something like the following:
Code:
#!/bin/bash
for i in {1..1440}; do
mysql -ufoo --password='' -te "show full processlist" > /home/foo/log/show_processlist.log.`date +\%Y\%m\%d-\%H\%M` 2>&1
sleep 5;
done
Say you save this script as filename
Code:
mysql_log.sh
Then, all you have to do now is to configure your crontab to run this script at exactly 5 a.m (one time only). Something like this:
Code:
0 5 * * * mysql_log.sh 2>&1
That action will last till 7 am.
Hope it helps and I hope someone points a better solution too.
Hi,
Thanks in advance.
i need to kill a unix background running job after that job process completes.
i can kill a job by giving the following unix command
kill -9 processid
how to kill the job after the current process run gets completed ?
Appreciate your valuable help.
... (1 Reply)
Hi,
Thanks in advance.
i need to kill a unix background running job after that job process completes.
i can kill a job by giving the following unix command
kill -9 processid
how to kill the job after the current process run gets completed ?
Appreciate your valuable help.
Thanks... (7 Replies)
I run cron in solaris 10 zone. One cron job which syncing files to nfs mounted on container, creates after finishing another cron proccess(/usr/sbin/cron), and after 100 existing cron proccesses next cron job will not start. It's too weird for me, I'm not able to solve this problem. Theoretically... (3 Replies)
I would like to setup a Cron job to check weather X process is running or not. if it is not running then start that X process with a log message....
can any one help writing a script?
thanks (3 Replies)
Hi All,
I have got a shell script that excutes some job and mails me the output as an attachment.
While running the script manually, its perfect.
when i am scheduling the job through crontab, i am getting the mail.
but the attachment but this is a blank file.
after the scheduler run, i can... (2 Replies)
Hello,
I'd like to set a cron job that runs a shell script every 30 minutes or so to restart a java based service if the memory gets above 80%. Any advice on how to do this?
Thanks in advance!
- Ryan (19 Replies)
Hi ,
I have removed a cron for particular user , but cron job seems to be running even after the cron entry is removed. The purpose of the cron was to sendmail to user ( it uses mailx utility )
I have restarted cron and sendmail service still user is getting mail alerts from the cron job. And... (4 Replies)
Hi,
1)
If some job supposed to run on 1st of every month at 7 AM
In cron job when we have a blackout on the 1st ( i.e when 1st falls on a sunday ) how can we make the job run the next business day?
2) How can we run a job on 25th of every quarter 7 AM(jan,apr,jul,oct)
And if 25th... (5 Replies)
Discussion started by: System Admin 77
5 Replies
LEARN ABOUT DEBIAN
atsadc
ATSADC(1) local ATSADC(1)NAME
atsadc, atsa1, atsaftp, atsahttp -- counter-collection
SYNOPSIS
atsadc [ t n ] [ ofile ]
atsa1 [ t n ]
atsaftp
atsahttp
DESCRIPTION
System activity-data can be gathered on special request of a user [see atsar(1) ] or automatically, on a routine basis, as described here.
Usually the kernel maintains statistical counters that are incremented as various system actions occur. These include counters for CPU uti-
lization, disk utilization, memory utilization and various network statistics.
The program atsadc and the shell-script atsa1 are used to collect, save, and process these counters.
The program atsadc (the data collector) samples system data n times with an interval of t seconds between samples, and writes in binary
format to ofile or (default) to standard output. The sampling interval t should be greater than 1 second. If t and n are omitted, a special
reset-record is written. This facility is used when booting to a multi-user state, to mark the time at which the counters restart from
zero. For example, the reset-mark can be added to the daily data by the command:
/usr/local/bin/atsadc /var/log/atsar/atsa`date +%d`
Note that this entry is written to the /etc/rc.d/init.d/atsar file.
The shell-script atsa1 is used to collect and store data in the binary file /var/log/atsar/atsadd where dd is the current day of the month.
The arguments t and n cause records to be written n times at an interval of t seconds, or once if omitted. Furthermore this script takes
care that log-files older than a week are removed once a day.
A file containing following entries should be added to the /etc/cron.d directory to produce records every 20 minutes during working hours
and hourly otherwise:
0 * * * 0-6 root /usr/local/bin/atsa1
20,40 8-17 * * 1-5 root /usr/local/bin/atsa1
See crontab(1) for details.
The shell-script atsaftp counts the new transfers registered in the FTP-logfile(s) since the previous time this script was activated; the
new counters are stored in the /var/log/atsar/ftpstat file in ASCII-format. The names of the FTP-logfiles to be watched are specified in
the /etc/atsar.conf configuration-file.
The shell-script atsahttp counts the new transfers registered in the HTTP-logfile(s) since the previous time this script was activated; the
new counters are stored in the /var/log/atsar/httpstat file in ASCII-format. The names of the HTTP-logfiles to be watched are specified in
the /etc/atsar.conf configuration-file.
Both scripts must be activated just before the program atsadc is started, which also collects these counters.
FILES
/var/log/atsar/atsadd
Daily data file, where dd are digits representing the day of the month.
SEE ALSO atsar(1), crontab(1)AUTHOR
Gerlof Langeveld, AT Computing (gerlof@ATComputing.nl)
AT Computing July 2004 ATSADC(1)