Visit Our UNIX and Linux User Community


crontab


 
Thread Tools Search this Thread
Top Forums UNIX for Dummies Questions & Answers crontab
# 1  
Old 09-01-2011
crontab

hi,

i have to backup a database everyday on a Sun Microsystem.

i have been looking around and have found that crontab might be the answer.

the list of steps that have to be followed for me to get the database is:

1. on cmd telnet the equipment.
2. put the user name and password.
3. i normally log in as oracle.
4. so then oracle>cd /opt/hlr/trans/exp
5. ./expDB (which gives me the menu)
6. then i insert values like 3 ( which tells me to do the subscriber backup)
7. then i press yes
8. now i need to save the file by a specific file name and i need to increment by 1 for each new backup that i make.



my list of questions is:

1. how do i check which editor is available on the system?
2. will 01 3 * * * ./expDB work as a command on contrab?
3. where i have to select 3, will 02 3 * * * 3 work?
4. how do i work around for the renaming of the file?


awaiting your precious input,

many thanks,
# 2  
Old 09-01-2011
If You could look into expDB script and find out what's going on if You choose "3", You could cut it out of that script, delete the "yes" question and add script in that form to cron on Oracle machine. Incrementation of the filename could be done with simple `date` adding. You didn't tell if name of backup file is given as argument, or is it another question from the original script?
# 3  
Old 09-01-2011
how will i know what goes on when i choose 3 and yes? i mean how can i cut that out from the script?

ok for incrementation of the filename: `date +%d%m%y'??

thanks for your help, really appreciate/
# 4  
Old 09-01-2011
Can You paste somewhere expDB script? Unless it's not a script but some kind of binary...
To check what kind of file is it try after logging:
Code:
file /opt/hlr/trans/exp/expDB

If it's some kind of script try to see what's inside, You can try some of editors:
pico, nano, mcview, vi, vim... followed by scriptname, eg:
Code:
pico /opt/hlr/trans/exp/expDB

# 5  
Old 09-01-2011
file /opt/hlr/trans/exp/expDBnot a valid file or directory.

oracle>cd /opt/hlr/trans/exp
oracle> cd expDB

expDB is not a directory

Smilie

---------- Post updated at 04:06 AM ---------- Previous update was at 04:04 AM ----------

Quote:
Originally Posted by sulti
Can You paste somewhere expDB script? Unless it's not a script but some kind of binary...
To check what kind of file is it try after logging:
Code:
file /opt/hlr/trans/exp/expDB

If it's some kind of script try to see what's inside, You can try some of editors:
pico, nano, mcview, vi, vim... followed by scriptname, eg:
Code:
pico /opt/hlr/trans/exp/expDB

pico not available, vi /opt/hlr/trans/exp/expDB = cannot see the script
# 6  
Old 09-01-2011
What is the output of the command?
Code:
file /opt/hlr/trans/exp/expDB

# 7  
Old 09-01-2011
not a directory
 

Previous Thread | Next Thread
Test Your Knowledge in Computers #501
Difficulty: Easy
If a piece of code adds two numbers together and stores the result, there should be a comment that explains the process in the source code.
True or False?

10 More Discussions You Might Find Interesting

1. UNIX for Dummies Questions & Answers

at vs crontab

Hi, can someone explain the differences between using the at and crontab commands. When would you use one command over the other? TIA Dom (1 Reply)
Discussion started by: domburf69
1 Replies

2. Shell Programming and Scripting

crontab

I have a crontab entry,but it is not working. Can anybody help me in this regard?? (2 Replies)
Discussion started by: Sourav_Paul
2 Replies

3. UNIX for Advanced & Expert Users

Help regarding crontab

Dear All jobs are scheduled in crontab . To view this I use crontab -l . But suddenly today I am not able to see any jobs that is being scheduled in crontab. when I type crontab -l , I am seeing nothing.I am not logging through admin user(i dont have it).But I can schedule jobs through... (3 Replies)
Discussion started by: tkbharani
3 Replies

4. UNIX for Advanced & Expert Users

Crontab help

hi, I run a .sh file using crontab. I need to know the path of the file . Previously when I run the file alone , i used "pwd" but now when using crontab it gives the temp directory of the file. Is there any way I can find the absolute path of the file when i execute it ? Regards, Ranga (7 Replies)
Discussion started by: r_W213
7 Replies

5. Shell Programming and Scripting

Using Crontab

Hi All, I've a shell script which calls a Sybase stored procedure to do some functionality. I want to schedule the running of this script by crontab. I'm using Solaris 5.8. When i executed the following command crontab -l i got the output as crontab: can't open your crontab file How... (10 Replies)
Discussion started by: sumesh.abraham
10 Replies

6. UNIX for Dummies Questions & Answers

crontab

hi all how to schedule the crontab file in unix? (2 Replies)
Discussion started by: ss4u
2 Replies

7. Shell Programming and Scripting

help with crontab

i have a ksh script that creates messages in a temp directory and then sends them out using the sendmail command and i'm trying to set it up to run every night with crontab. So the basic gist of the script is #create temp dir and messages ... #loop through each message and send using sendmail... (3 Replies)
Discussion started by: bob122480
3 Replies

8. UNIX for Dummies Questions & Answers

Crontab

How can I run "crontab" (parameters) every 6 hours on solaris machine? Thanks (1 Reply)
Discussion started by: gen4ik
1 Replies

9. UNIX for Dummies Questions & Answers

about crontab

dear all , does any one now how can i become sure that the crontab that i put was working successfully not by looking for thr result of the sheduled task but from a log for the crontab or something similar and i need to check that the cron i wrote is correct 00 15 * * 0,1,2,3,6... (2 Replies)
Discussion started by: habuzahra
2 Replies

10. UNIX for Dummies Questions & Answers

crontab

Hi I have a shell script which works fine at the command line and does works in crontab also but does not send the output to mail as other scripts do by default. 10 1 * * * /export/home/test/report_script by default should send the output to mail but the script runs OK and the output... (1 Reply)
Discussion started by: run_time_error
1 Replies

Featured Tech Videos