Sponsored Content
Top Forums Shell Programming and Scripting Automating Database scripts in UNIX Post 100704 by mercy on Wednesday 1st of March 2006 11:18:55 AM
Old 03-01-2006
use cron

you can get more info about it typing command like this:
$man cron
$man crontab


if you use mysql also watch
$man mysql
if postgres
$man psql

or post your problem more detaled

p.s. crossposting - evil of the world
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Automating interactive scripts

Hi all, I am trying to write a program that will automate interactive scripts that use 'pkgadd'. Easily enough I can use 'pkgask' and a response file for most of what I want to do, but unfortunately there are parts of some pkg installations that are configured to only take input from /dev/tty!!... (2 Replies)
Discussion started by: bookoo
2 Replies

2. HP-UX

Automating Database scripts in UNIX

Hi everybody, can someone please suggest me how to implement the running of SQL table scripts(.sql) at a specific time automatically in UNIX ?Thanks (0 Replies)
Discussion started by: konquistador
0 Replies

3. UNIX for Dummies Questions & Answers

Automating Database scripts in UNIX

Hi everybody, can someone please suggest me how to implement the running of SQL table scripts(.sql) at a specific time automatically in UNIX ?Thanks (0 Replies)
Discussion started by: konquistador
0 Replies

4. Shell Programming and Scripting

Automating back up of database tables

Hi all, i would like to set a cronjob to back up my db tables. I have written the par file, i would like to know how can i execute a exp command in a shell script. my par file userid=admin/password file=backup.dmp log=backupLOG.log tables= (Tables 1, Tables 2)My cron job script will be... (1 Reply)
Discussion started by: new2ss
1 Replies

5. UNIX for Dummies Questions & Answers

Automating UNIX backups?

Hi all, I'm quite limited in UNIX unfortunately for me, and need to find a solution to something thats giving me headaches every morning. We need to make daily backups of a server we have in the office every morning, as well as then FTPing the created backup files over to a specific FTP address... (3 Replies)
Discussion started by: de049
3 Replies

6. Shell Programming and Scripting

Shell Scripts for automating server inventory for unix servers

Dear Team, I am very new to shell scripting & and presently monitoring unix boxes I am looking for a shell script which will give me the below output script should contain - hostname,OS Version,CPU details, Physical Memory, Partitions Details, Network Details and Software Installed,... (5 Replies)
Discussion started by: whizkidash
5 Replies

7. Shell Programming and Scripting

Automating A Perl Script over a database

Dear Scripting Gods I've never done shell scripting before and have only recently got to grips with Perl, so apologies for my naivity. I've written a perl program which takes in two files as arguments (these are text documents which take in the information I need) The perl program spits out a... (1 Reply)
Discussion started by: fraizerangus
1 Replies

8. Shell Programming and Scripting

using unix scripts database access

i want to access database (sql script) within a unix script. help me (2 Replies)
Discussion started by: chamaraa
2 Replies

9. Web Development

Help me in automating the recycling of UNIX server

Hello everyone...I am very new to UNIX hence needs your help in below. i have written a script to change some configuration in property files and its working fine.but to reflect that change at the application i want to recycle WAS and ihs.i.e. run below start and stop commands at /usr/local/bin ... (2 Replies)
Discussion started by: Sanaa
2 Replies

10. UNIX for Beginners Questions & Answers

Automating UNIX/Solaris password resets

Hi, we are running solaris 5.10 and looking for solutions to automate password resets? Plz assist. Thanks, Sridhar (6 Replies)
Discussion started by: chvgms
6 Replies
PIDOF(8)						Linux System Administrator's Manual						  PIDOF(8)

NAME
pidof -- find the process ID of a running program. SYNOPSIS
pidof [-s] [-x] [-o omitpid] [-o omitpid..] program [program..] DESCRIPTION
Pidof finds the process id's (pids) of the named programs. It prints those id's on the standard output. This program is on some systems used in run-level change scripts, especially when the system has a System-V like rc structure. In that case these scripts are located in /etc/rc?.d, where ? is the runlevel. If the system has a start-stop-daemon (8) program that should be used instead. OPTIONS
-s Single shot - this instructs the program to only return one pid. -x Scripts too - this causes the program to also return process id's of shells running the named scripts. -o Tells pidof to omit processes with that process id. The special pid %PPID can be used to name the parent process of the pidof pro- gram, in other words the calling shell or shell script. NOTES
pidof is simply a (symbolic) link to the killall5 program, which should also be located in /sbin. When pidof is invoked with a full pathname to the program it should find the pid of, it is reasonably safe. Otherwise it is possible that it returns pids of running programs that happen to have the same name as the program you're after but are actually other programs. SEE ALSO
shutdown(8), init(8), halt(8), reboot(8) AUTHOR
Miquel van Smoorenburg, miquels@cistron.nl 01 Sep 1998 PIDOF(8)
All times are GMT -4. The time now is 07:44 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy