| Author |
Message |
    
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5806
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, October 25, 2007 - 12:39 pm: |    |
thanks proline mama  |
Proline
Yavvanam Kaatesina Bewarse
Username: Proline
Post Number: 3934
Registered: 10-2004
Posted From: 67.151.180.185
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, October 25, 2007 - 12:35 pm: | |
hemanth,
In TOAD, it is easy.
go to these tabs, DATABASE ->CREATE-->JOB.
Then you get 'create job' pop up window. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5799
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, October 25, 2007 - 12:11 pm: | |
aagu mama chosthanu. |
420
Yavvanam Kaatesina Bewarse
Username: 420
Post Number: 2768
Registered: 12-2006
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, October 25, 2007 - 11:50 am: | |
other wise if you want to know it the hard way ..loook at this
DECLARE
X NUMBER;
BEGIN
SYS.DBMS_JOB.SUBMIT
(
job => X
,what => 'SCOTT.functionName()
(UNCC /* VARCHAR2 */ ,
PROJID /* VARCHAR2 */ ,
JOBID /* VARCHAR2 */ );'
,next_date => to_date('25-10-2007 18:45:26','dd/mm/yyyy hh24:mi:ss')
,interval => 'TRUNC(SYSDATE+1)'
,no_parse => FALSE
);
:JobNumber := to_char(X);
END; |
420
Yavvanam Kaatesina Bewarse
Username: 420
Post Number: 2767
Registered: 12-2006
Posted From: 85.144.112.59
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, October 25, 2007 - 11:47 am: | |
allane TOAD loo tabs click cheskuntuu velthee.. you will get JOBS there you can create a job and schedule .. |
Ravanabrahma
Mudiripoyina Bewarse
Username: Ravanabrahma
Post Number: 5797
Registered: 06-2004
Posted From: 65.196.167.82
Rating:N/A
Votes: 0(Vote!) | | Posted on Thursday, October 25, 2007 - 10:32 am: | |
nenu daily run cheyyali konni procedure.
nenu maamuluga TOAD loki velli aa procedure ni click chesi merupu symbol ni click chesi run chesthunnaa..kani ala kakunda vaatini oka time lo run ayi commit ayyela schedule chestham elaa?? |
