Hi,
How can I insert values into table only a particular date of each & every month?
Thanks
jaheena
Loading
Know the answer? Post it — somebody with the same question will find it here.
Sign in to answer this question
It is the same account you read, post and publish with — and you will come straight back to this page.
Suthish NairPosted Mar 7, 2011, 2:19 PM
jaheena jamalPosted Mar 4, 2011, 3:55 AM
This answer is okey, but one doubt, some month have 28 days or 30 days or 31 days . then what can i do ?
Thanks
Jaheena
ShankeyPosted Mar 4, 2011, 3:40 AM
You can write a storeprocedure and schedule the job using either of the following ways:
1)http://msdn.microsoft.com/en-us/library/ms191439.aspx
2)Using DBMS_JOB package we can schedule the job.
Ex:
DBMS_JOB .SUBMIT
DBMS_JOB .RUN.
Using DBMS_SCHEDULER
SYNTAX FOR CREATING JOB
dbms_scheduler.create_job(
ob_name IN VARCHAR2
job_type IN VARCHAR2
job_action IN VARCHAR2
number_of_arguments IN PLS_INTEGER DEFAULT 0
start_date IN TIMESTAMP WITH TIME ZONE DEFAULT NULL
repeat_interval IN VARCHAR2 DEFAULT NULL
end_date IN TIMESTAMP WITH TIME ZONE DEFAULT NULL
job_class IN VARCHAR2 DEFAULT 'DEFAULT_JOB_CLASS'
enabled IN BOOLEAN DEFAULT FALSE
auto_drop IN BOOLEAN DEFAULT TRUE
comments IN VARCHAR2 DEFAULT NULL);
Suthish NairPosted Mar 4, 2011, 3:25 AM
jaheena jamalPosted Mar 4, 2011, 3:21 AM
When a person registered in this company, then he will get a certain amount of money to him on particular date that who registered. same like that he will get amount on a particular date in each & every month. Please help me.
Thanks
Jaheena
Suthish NairPosted Mar 4, 2011, 3:14 AM