variable job number
EXEC dbms_job.submit(:job, 'username.procname;',
next_day(trunc(sysdate),'SUNDAY')+2/24,
'next_day(trunc(sysdate),''SUNDAY'') +2/24');
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"miki" <antonioabril_at_gmail.com> a écrit dans le message de
news:4a276719.0410260301.592cea52_at_posting.google.com...
> I can to call a stored procedure from a job every night, anybody have
> a example that made this??
>
> thanks
Received on Tue Oct 26 2004 - 08:16:37 CDT
