One Time Immediate Job in Oracle

One Time Immediate Job can be created by using "dbms_job" and "dbms_scheduler" both.

1) One Time Immediate Job using dbms_job
  declare
    l_jobid number := null;
  begin
    dbms_job.submit 
    (
      job       =>  l_jobid,
      what      =>  'sp_proc;',
      next_date =>  sysdate,
      interval  =>  null
    );
    commit;
  end;
  /

Always remember to issue a COMMIT statement immediately after dbms_job.submit.


2) One Time Immediate Job using dbms_scheduler
  begin
    dbms_scheduler.create_job 
    (  
      job_name      =>  'One_Time_Job',  
      job_type      =>  'PLSQL_BLOCK',  
      job_action    =>  'begin sp_proc; end;',  
      start_date    =>  sysdate,  
      enabled       =>  TRUE,  
      auto_drop     =>  TRUE,  
      comments      =>  'one-time job');
  end;
  /



Related Posts:
- dbms_scheduler repeat_interval tip with create_schedule
- How to connect SQLPlus without tnsnames.ora
- SQL Interview Question Answers
- Oracle Database 12c New Features for Developers

53 comments:

  1. Hi, can anyone tell me why user_tab_cols is showing an additional non existing column name?
    When I queried a table say ex. select COLUMN_NAME from user_tab_cols where table_name='LYT_CYCLE_SUMMARY'
    I am getting SYS_NC00011$,OPENING_PTS_BAL_N,CLOSING_PTS_BAL_N,CYL_SUMM_STATUS_V.......
    14 columns when there is only 13 columns. Can anyone explain why is this happening? SYS_NC00011$ is the additional column im getting and its data type is shown as RAW and it doesn't have a COLUMN_ID.

    ReplyDelete
    Replies
    1. use user_tab_columns
      https://forums.oracle.com/thread/310121

      Delete
  2. Thanks for posting this, I never thought about using Scheduler for a one-time job, but I needed to twice last week! Talk about putting new knowledge to use quickly, your post was very timely.

    ReplyDelete
  3. Ofcourse , It is nice posting about oracle jobs .

    ReplyDelete
  4. I'd like to thank you for the efforts you have put in penning this blog.
    I'm hoping to view the same high-grade content by you in the future as well.
    In truth, your creative writing abilities has inspired me to
    get my very own website now ;)

    ReplyDelete
  5. Hey very nice blog!

    ReplyDelete
  6. My family members every time say that I am wasting my time here at net, however I know I am getting knowledge every day by reading such pleasant posts.

    ReplyDelete
  7. Nice replies in return of this question with genuine arguments and telling the whole thing about that.

    ReplyDelete
  8. Awesome and interesting article. Great things you've always shared with us. Thanks. Just continue composing this kind of post. https://europa-road.eu/hu/nehezgep-szallitas.php

    ReplyDelete
  9. Excellent Blog! I would like to thank for the efforts you have made in writing this post. I am hoping the same best work from you in the future as well. I wanted to thank you for this websites! Thanks for sharing. Great websites! how to find job fast

    ReplyDelete
  10. dbms_scheduler.create_job ...immediate run with a gap of 1 minute
    puts job in scheudled state and not running..

    ReplyDelete
  11. I haven’t any word to appreciate this post.....Really i am impressed from this post....the person who create this post it was a great human..thanks for shared this with us. poker88

    ReplyDelete
  12. It’s very informative and you are obviously very knowledgeable in this area. You have opened my eyes to varying views on this topic with interesting and solid content. job bank

    ReplyDelete
  13. Hello, this weekend is good for me, since this time i am reading this enormous informative article here at my home. Std test

    ReplyDelete
  14. Hello, this weekend is good for me, since this time i am reading this enormous informative article here at my home. Autoankauf

    ReplyDelete
  15. You completed a number of nice points there. I did a search on the issue and found nearly all people will have the same opinion with your blog. Bd Job portal website

    ReplyDelete
  16. Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. 먹튀검증커뮤니티

    ReplyDelete
  17. I read your post carefully. It seems like a good post, very concise and well summarized to the point. I will bookmark this article. 안전놀이터

    ReplyDelete
  18. autoankauf

    Autoankauf von gepflegten Gebrauchtwagen, oder Fahrzeuge mit Mängeln für den Export. Auto verkaufen mit Schaden, Unfallwagen oder auch mit Motorschaden ohne Nebenwirkungen. Fahrzeugalter möglichst unter 10 Jahren.


    https://www.autoankauf-roman.de/

    ReplyDelete
  19. Quality content will have a positive effect on readers / viewers, of course we found quality content, I am very impressed with your website, thank you from our big family joker123

    ReplyDelete
  20. I can’t believe focusing long enough to research; much less write this kind of article. You’ve outdone yourself with this material without a doubt. It is one of the greatest contents. 팔팔카

    ReplyDelete
  21. This is such a great resource that you are providing and you give it away for free. I love seeing blog that understand the value of providing a quality resource for free. textbook answers

    ReplyDelete
  22. Hello I am so delighted I located your blog, I really located you by mistake, while I was watching on google for something else, Anyways I am here now and could just like to say thank for a tremendous post and a all round entertaining website. Please do keep up the great work. Domanda di Visto degli Stati Uniti

    ReplyDelete
  23. If you are looking for more information about flat rate locksmith Las Vegas check that right away. indian visa online

    ReplyDelete
  24. it was a wonderful chance to visit this kind of site and I am happy to know. thank you so much for giving us a chance to have this opportunity.. visto per il canada

    ReplyDelete
  25. 사실 사설사이트를 이용할 땐 적은 금액으로 사용해서 배팅하는 게 좋지만, 만약 그럴 상황이 안되면 검증이 완료된 안전한 사이트에서만 배팅 해야 합니다. 먹튀

    ReplyDelete
  26. 자본이 강한 업체인가 : 자본금이 10 억 원 미만인 사설업체는 언제든지 위험이 일어날 수 있는 확률이 있는 아주 위험한 사이트라고 생각해도 무방합니다. 유저들이 가장 좋아하며 항상 꿈꾸는 정배의 날! 메이저놀이터

    ReplyDelete
  27. This particular is usually apparently essential and moreover outstanding truth along with for sure fair-minded and moreover admittedly useful My business is looking to find in advance designed for this specific useful stuffs… korea-onlinecasino.com

    ReplyDelete
  28. This is certainly what's more a good report that i definitely enjoyed reading reviewing. It is actually no regularly that i contain the risk to discover a specific thing. securityguardla.com

    ReplyDelete
  29. Famous Interior Designers. Make Your House Feel Like a Home. Our Professionals Can Help You Every Step of The Way Through The Interior Design Process 먹튀...

    ReplyDelete
  30. Welcome to The Lord Shiva Songs Channel, your search for Peace & Calmness ends ... Subscribe for Most Effective Lord Shiva Mantras 메이저공원:

    ReplyDelete
  31. his site seems to inspire me a lot. Thank you so much for organizing and providing this quality information in an easy to understand way. I think that a healthy era of big data can be maintained only when such high-quality information is continuously produced. And I, too, are working hard to organize and provide such high-quality information. It would be nice to come in once and get information.

    Also visit my site:토토사이트

    ReplyDelete
  32. Please post useful information often. We will continue to visit in the future. Have a good day. 토토커뮤니티순위

    ReplyDelete
  33. I like your blog. i ma happy to read your blog its very informative and your blog is really good and impressive you made 안전토토사이트

    ReplyDelete
  34. I'm reading it well. This is something that Your postdesign as share helped me a lot 메이저사이트

    ReplyDelete
  35. Extremely overall quite fascinating post. I was searching for this sort of data and delighted in perusing this 토토검증사이트

    ReplyDelete
  36. How are you going to handle your messy hair which is usually ruining anyone's appearance though thy have good feature. This can therefore affects a person's self confidence. This is because by changing one's hairstyle alone can change a person's appearance. hair color

    ReplyDelete
  37. Very informative post! There is a lot of information here that can help any business get started with a successful social networking campaign. kündigen

    ReplyDelete
  38. Situs poker terbaik dan terpercaya di indonesia di mana kami bisa deposit pulsa dan via transfer dan ada bonus harian bagi para member yang online silahkan bergabung di situs kami. https://agenbettingpoker.com

    ReplyDelete
  39. Situs poker terbaik da terpercaya di indonesia di sini kita bisa deposit pulsa ada juga bonus harian dari setia pemain yang online mari bergabung di situs kami. IBOPLAY

    ReplyDelete
  40. Hi there, yeah this post is genuinely nice and I have learned a lot of things from it concerning blogging, thanks. Zoro Tools Plumbing Promo Codes

    ReplyDelete
  41. Thanks for sharing such a usefull and informative content, your post is awesome that will be understanding for everyone.
    You can also check my link below:
    Ceramic Braces Cost in Chennai
    Best Reselling App in India

    ReplyDelete
  42. https://goostrey.info/oman-email-lists/
    https://goostrey.info/pakistan-email-lists/
    https://goostrey.info/peru-email-lists/
    https://goostrey.info/philippines-email-lists/
    https://goostrey.info/poland-email-lists/
    https://goostrey.info/portugal-email-lists/
    https://goostrey.info/puerto-rico-email-lists/

    ReplyDelete
  43. Thank you once more for all of the expertise you distribute,Good post. I become very inquisitive about the article

    ReplyDelete
  44. Exceptionally noteworthy post about Locksmith baymeadows fl. Its extremely extraordinary post I have some significant data on your blog its exceptionally accommodating for me.

    ReplyDelete
  45. Oracle DBAs play a crucial role in managing and maintaining databases, ensuring data integrity, security, and availability. Their responsibilities include database installation, configuration, performance tuning, backup and recovery, and troubleshooting. Organizations highly value these skills. Oracle DBA training in Pakistan

    ReplyDelete
  46. การเล่นของค่าย pg slot เว็บ PG เว็บเกมที่มีเกมให้ได้ทดลองเล่นฟรี แล้วก็ยังเป็น PG SLOT รูปแบบใหม่ตอนนี้ของปีแตกง่ายแม้มีทุนน้อยก็เล่นได้

    ReplyDelete