Hi guys today i'll bring to you a new problem that i need to execute.
So what i need to do it's create a script that:
conect to some database
logon
run a .sql script
logoff
and close the connection
after that, put this script on the crontab
To set up the crontab it's ok for me, i think it's not a big deal. One more thing to do i need this file, cause my boss need to validate my task
SPOOL sspev_host_cleanup.log
Any help please?
You need that file as in what? Is it on the wrong machine?
Hi Corona688.....
I really don't understood anything you asked, but i'll try my best again, it's ok.
I have on my power a file .sql this script a i need to execute in few days, but i need to use the crontab cause the person who will be checking my works right? so We have differences of schedule.
Then i need to create a script that conect to data base, run this .sql script then
disconect to the dababase, besides get the file SPOOL spv_host_cleanup.log and send it by mail.
i guess the better idea it's create some script which do all of that.
Have a look here:
It is exactly what this piece does...(well need a bit of customizing... but the skeleton is there...)