Quote:
How do I se it up so I can receive an email after execution?
It matters what you are looking for - the entry you posted earlier would automatically send email to the oracle user if there was an error or any output - see the man page for crontab.
Quote:
If I normally run the script as oracle, then does that mean the script is set for executable by oracle?
If you can run the script as oracle, then the script is set for executable in some way to allow the oracle account to run it. It may be allowing the world to run it - simply look at the file with ls -l
Permissions will rwx or r-x. The userid that owns the file will be listed (may be oracle)
ls -l myscript
-rwx-r-xr-- 1 oracle dba 88 Nov 7 2003 myscript
This file is owned by oracle but allows execution by anyone in the dba group, by oracle (since it owns it) but only read for anyone else.
Quote:
I cannot open crontab -l as oracle and when I do a crontab -e it opens to vi.
You don't see anything with crontab -l because there is nothing there yet. Do the crontab -e and add this
* * * * * date > /tmp/oracle-test.date
Exit as you normally do from vi (saving the file wq). Then run crontab -l and you should see that entry.
Quote:
Do I have to be root in order to submit a crontab? If I don't - how do I exit crontab, like I exit vi normally - (wq!)??
Any user not listed in the cron.deny would be able to create a crontab. Yes, exit just like you normally do getting out of vi.