Sitemap

Amicuk Programming Answers

Job creation on particular days in week

-0001-11-30   Views:0

Advertisement

hi All, OS : RHEL 5.7 DB : 11.2.0.2 I have created one job. I want to run one procedure from Monday to Saturday at 10AM. Below is my code. Please check the code and tell me is it correct because i dont have that much idea about scheduling a job. have

hi All,
OS : RHEL 5.7
DB : 11.2.0.2
I have created one job. I want to run one procedure from Monday to Saturday at 10AM.
Below is my code.
Please check the code and tell me is it correct because i dont have that much idea about scheduling a job.
have i wrote that "job_action" section rightly? -- "TEST_PROCEDURE" is my procedure.
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'TEST_JOB',
job_type => 'STORED_PROCEDURE',
job_action => 'exec TEST_PROCEDURE;',
start_date => SYSTIMESTAMP,
repeat_interval => ‘freq=weekly; byday=mon,tue,wed,thur,fri,sat; byhour=10; byminute=0; bysecond=0;’,
end_date => NULL,
enabled => TRUE,
comments => 'Procedure will run From Mon to SAT at 10 AM.');
END;
Regards.

The replay answer
Advertisement
Hi all,
After your all comments and reading some documnets I have changed only "JOB_ACTION" and "‘freq=daily" parameter which is given below :
BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'TEST_JOB',
job_type => 'STORED_PROCEDURE',
job_action => TEST_PROCEDURE',
start_date => SYSTIMESTAMP,
repeat_interval => *‘freq=daily;* byday=mon,tue,wed,thur,fri,sat; byhour=10; byminute=0; bysecond=0;’,
end_date => NULL,
enabled => TRUE,
comments => 'Procedure will run From Mon to SAT at 10 AM.');
END;
I think this must work and suppose i want to run this from tommorrow, not nw then what should i mentioned?
Regards.

Go to See the other 11 answers

Fields in Creation of free goods VBN1

Category:DefaultRelease time:2015-10-11Views:130

hi everybody, Can somebody expalin in detail the fields in creation of free goods(T-vbn1) like free goods quantity,additional quantity,documnet quantity and calculation rule.... <b>Please dont copy paste anything form SAP help....I read that one....[More]

Account determination error - in creation of invoice

Category:DefaultRelease time:2015-10-11Views:130

Hello experts, i have an error in creation of invoice, after( pgi post goods issue) will you please help me out to solve this error. thanks & Regards, yogesh rainahello sir, After going throuth this path it shows no gl account in account determinatio[More]

Automatic PO creation of free text PR

Category:DefaultRelease time:2015-10-11Views:130

Hi! We have all our PRs in free text since we are not yet using material master. One of our purchase organization will only order from one vendor and they will enter that vendor and price in the PR. Is it possible to create a PO automatically from th[More]

Issue in creation of plant related data at receiving server using BD10

Category:DefaultRelease time:2015-10-11Views:130

Hi all, This is regarding Material master creation using B10.I am using MATMAS05 message type for sending data from one system to another.Data is sent and received successfully.When i go in mm03 i can see all the views created successfully accept vie[More]

Issue in Creation of new Value Field in CO-PA

Category:DefaultRelease time:2015-10-11Views:130

Hi, I have a query in CO-PA Value Field Linking. In my Development Client, 1. Created a New Value Field (No Transport Request Generated) 2. Linked to the above to new Conditon type created in SD. (Tranport request was generated) i.e. in Flow of Actua[More]

Issue in creation of control cycle

Category:DefaultRelease time:2015-10-11Views:130

Dear Gurus, During creation of control cycle (LPK1), the fields for source information is not appearing in my system. I compared control cycle in a different ECC system where source information is appearing. How can make the screen appear in my ECC s[More]

Issue in Creation of XML file from ABAP data

Category:DefaultRelease time:2015-10-11Views:130

Hi, I need to create a XML file, but am not facing some issues in creation of XML file, the in the required format. The required format is -<Header1 1st field= u201CValueu201D 2nd field= u201CValueu201D>    - <Header2 1st field= u201CValueu201D 2[More]

What are the mandatory fields while creation of material master in differen

Category:DefaultRelease time:2015-10-11Views:130

what are the mandatory fields while creation of material master in different views?Hi Gopi,   This is purely depends on the function configuration, which would be done MM consultants.  Kindly check with them. thanks & regards Kishore Kumar MaramRead[More]

BADI for changing fields during Creation of BP in CRM

Category:DefaultRelease time:2015-10-11Views:130

Hello to everyone,   I need to find a BADI (or other way) to default several fields during BP creation in CRM (4.0 SR1 SP9). The fields I will like to set are TAX TYPE, TAX NUMBER, TAX CATEGORY, etc.. I have found the BADI BUPA_TAX_UPDATE but i dont[More]

Error in creation of purchase materials/Goods receipt against PO(FI-MM)

Category:DefaultRelease time:2015-10-11Views:130

Hi All, While processing FI - MM integration iam facing below errors,request to guide me with same 1) While creation of purchase materials Valuation class 7920 not allowed for material type Raw material Message no. M3180 Diagnosis The combination of[More]

Reg View creation in Generic

Category:DefaultRelease time:2015-10-11Views:130

Hi SDN, Im trying to create Generic Data source of View Method. I wanted to create View on BSID ( Closed Customer Invoices) and BSAD ( Open Customer invoices) Tables, But while creating its giving error as "THERE IS NO RELATION BETWEEN THE TABLES&quo[More]

Hot
Hi Gurus, For around 2000 material we need to step-up a ABC value indicator in MRP1/plant 0910 of Material Master. We have issues when doing with MM17. Want some sugestions.... If we use LSMW how to proceed?Hi, If you have an issue with MM17, you can [More]
Hello, My main question, after reading the man page and googling, I can't find any way to create a DMG file with more then one partition. Is this even possible? My finaly goal is to attach those with -mountRandom and - nobrowse from inside a cocoa.ap [More]
I had a stolen macbook pro 15 "MD546LL/A S/N: C0******24T. Please help me find it! It is very important to me, my 1.5 year of heavy labour! <Edited by Host>NOTE:  If you purchased the computer with a credit card it's possible you have theft cov [More]
waiting fr replies//If you upgrade to Lion it comes bundeled with it! To get it on your Mac Pro just copy the aplication from the aplication folder on your MacBook.  You can do this via a thumb drive or over a local network connection.Read other 2 an [More]
I'm trying to load photos from iPhoto to my mother's new Christmas present digital photo frame which is not Mac compatible. I made a new iPhoto folder of the photos I want, then tried dragging that onto the camera device icon in iPhoto. No go. Then I [More]
hey, everything seems to be working fine in my itunes, but when i go to "get info" and try to change the given info all of the blocks are grey and i cannot select them. how can do i change the info?You delete music that was synced to your phone [More]
I have Lion OS X 10.7 on my MacBook Pro 15'' and I've tried to install an application for an external Maxtor hard drive. But it seems to be compatable only with previous Operating Systems because now every 5 seconds I get the popup "You can't open th [More]
Afternoon My partner and I both have Mac laptops as our primary computers - an MB and a PB. We'd like to share the same itunes library without having to leave one of the laptops on all the time, because one or either of them is regularly out of the h [More]
Hello! In Microsoft Outlook is possible to post Office files - File - Send To - Exchange folder After sync my IPAD with exchange, I can't see those files on IPAD. Could be an IOS limitation? CatalinHi, Thank you for you support. Kindly find the curre [More]
Hi all I have an issue with the sequence question type. If you have feedback, the draggable responses show over the top.  Please see grab. Is this a bug? I can't find any mention of it. It only seems to do it with certain responses. Makes it complete [More]