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
Can anyone help me? It would be very much appreciated. Thank you!I assume that you don't have a rescue email address (which is not the same thing as an alternate email address) set up on your account, as described in then steps 1 to 5 on the page tha [More]
How do I transfer photos from iPad mini to Sd card for backup?You can copy photos from Camera Roll to a wireless flash drive (Micro SD Card) http://www.sandisk.com/products/wireless/flash-drive/Read other 4 answers [More]
My broadband drops out and  all the lights flash. Just joined netflix and we can't watch anything as it just keeps buffering. At that point I check the bt home hub v2 b and the lights are going crazy. Also at night when I am checking my emails on my [More]
Hi there, we are currently developing an email to multiple IDOC szenario which works fine so far. We receive emails with an attachement. In the mail-sender-chanel we use swap-bean and an itemfield parsing to get this attachement into xml. My problem [More]
What is the difference between using an @me email address for iCloud and the new option of an @icloud email address offered?The @icloud address operates like an alias to your @me address.  Any email sent to either your @me or @icloud address is route [More]
Hello - New user to BO Data Services Designer. Company is using Data Services Version 12.2. I have many tables that all need the same transformation- converting varchars fields to upper(varchar) fields Example: I have a table called Items. It has 40 [More]
Hi I have a JSF page where the user enters data and submits by clicking on the Submit button. My backing bean then takes the data and processes it. After successful processing, I want to direct the user to a non-JSF page. What is the best way of achi [More]
Hi sap gurus here below am mentioning my requirement details . automate the creation of sales order documents in sap ecc using data in orders5 idocs, mapped from data transmitted by customers via edi are from other outside systems. this interface mus [More]
I have bought ebook from itunes and i can read it on Ibook on my Iphone,but I want to read book on my macbook what should I do? please help me...which is a real shame. I 'married' Kindle very early on, so that's my format of choice. I like being able [More]
Hello Can anyone help answer a query we have regarding an upgrade we need to do on Prime Infrastructure, PI. We are running PI version 1.3 on VMware in a standard deployment. We want to upgrade to a Pro deployment. My understanding is that the only d [More]