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
I have a query which is : String query = "select FIRSTNAME, MIDDLEINITIAL, LASTNAME from user" ; now i have executed the above query ResultSet rs = stmt.executeQuery(query) ; Suppose i get 2000 rows in my resultset after execution. If i want to [More]
How to turn off the built-in display without having to change the power option ( Control Panel > Hardware and Sound > Power Options > Edit Plan Settings), close the window, or put the system to sleep. WQHD sucks. Most Icons (YouTube video player [More]
How can I get the download folder to remain on the docking stationNote if you don't have any folders on your Dock, note the trashcan is on one side of the dock with a divider between it and applications.  Minimized windows (with the yellow button on [More]
Hi Experts, The scenario is SAP R/3 sends idoc to PI.  PI converts this into a flat file and sends to Trading Partner through Seeburger AS2 adapter. We can trace the message content in XML format within PI using SXMB_MONI or RWB.   How to extract a c [More]
Hi gurus,   is it possible to assign differant pricing procedure to same vendor?Hi, One purchase organiztion can only have one Schema Group by "define schema group" in customizing ; and one Schema Group and one Schema Group Vendor can have one p [More]
I am looking for Transaction Codes or Path to get these reports 1 List of customer returns 2 List of goods receipts 3 List of Post Goods Issues 4 List of goods shipped 5 List of adjustment made to inventory by date/person. (Document it) 6 Inventory a [More]
Hi Everyone, I have the following hardware - iMac 2.66 Ghz Intel Core 2 8 GB Ram. This computer is over three years old, so this summer, I reformatted the hard drive, then installed Mountain Lion - I am running OS X 10.8.2 I reinstalled all of my app [More]
HI i upgrade my iPad air to iOS 8.0.2, then I couldn't find personal hotspot from setting and also I don't know how I can connect my laptop or iPhone to Internet via my iPad hotspotCellular Data Network have 4 Section: 1) Cellular Data 2) LTE setup ( [More]
I just wanted to let someone know that sample code for one of the workspace demos needs a change...in the no_shipping_demo script, it tries to run noShippingPopulate.sql when it should be no_shipping_populate.sql Then the demo works just fine. I trie [More]
Suddenly, my G4 Powerbook w/ Tiger only works on power cord, not battery. As soon as I unplug it, it shuts down and does not hold its time settings. How do I determine if its new battery time or something else? Thank you.Here's the same info from my [More]