I have a procedure say "sp_run_the proc".
I need to run this procedure every day at 1:00 AM.
In a way,i need to schedule a job to run this procedure at fixed time daily.
Can someone help me out as how exactly i could implement this? Not to forget that i am using Oracle 8i.