how can i insert values into table only a prticular dates of each month?

Question

Hi, How can I insert values into table only a particular date of each & every month? Thanks jaheena

Suthish Nair · Answer

If the query got resolved, then mark the post that helped you as Answer so will be helpful for others. Otherwise if you got the solution please share with us.

jaheena jamal · Answer

Suthish sir, 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

Shankey · Answer

hi jaheena, 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 Nair · Answer

sql: select DATEADD(MONTH, 1, GETDATE()).. or something else looking for..

jaheena jamal · Answer

Hi sir, 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 Nair · Answer

explain your thread with more information