| DBMS_JOB Urgent Please!!! [message #56833] |
Tue, 29 April 2003 13:36  |
Nivas
Messages: 2
Registered: April 2003
|
Junior Member |
|
|
Hello all , I have a small problem with DBMS_JOb.
Can anyone give me the DBMS_JOb.submit() statement for the following issue ?
I have a procedure sampleproc() to run as per the below mentioned table
ie. proc should rum on Monday 9'0 clock, 12'o clock, 3pm, 6pm, 9pm, 12am and from tue to friday it shoud run continuously i.e. 00hrs, 3am, 6am, etc etc
Please help me as soon as possible..
M T W TH F S
3 X X X X
6 X X X X
9 X X X X X
12 X X X X X
15 X X X X X
18 X X X X X
21 X X X X X
00 X X X X X
Thanks
Nivas
|
|
|
|
| Re: DBMS_JOB Urgent Please!!! [message #56841 is a reply to message #56833] |
Wed, 30 April 2003 03:27  |
psmyth
Messages: 81
Registered: October 2002
|
Member |
|
|
too hard ;-)
If you're running unix, set your job up as a shell script and run it through the cron scheduler - one entry to run it at 3,6,9,12,15,18,21 and 00 on Tu, Wed, Thu and Fri, and a second job to run it at 9, 12, 15, 18, 21 and 00 on Monday.
If you're running under MS, do the same under 'job scheduler'.
As useful as the dbms_job system is, personally I think there are easier ways of achieving the same thing.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
