title: Oracle job scheduler execution in daily one particular time, with two queries on that job task
body: <p>I need help in Oracle job scheduler every day 1:00 pm.<strong>I want execute two queries on that single job scheduler</strong>. Queries like </p>
  
  <p>first one is simple delete query .</p>
  
  <pre><code>delete from NEWS_NO_OF_VIEWS where TO_CHAR(MONTH_YEAR,'MM-YYYY') = 
                                                           TO_CHAR(SYSDATE,'MM-YYYY')
  </code></pre>
  
  <p>and second one is insert query </p>
  
  <pre><code>INSERT INTO NEWS_NO_OF_VIEWS(NEWS_TYPE, NO_OF_VIEWS, MONTH_YEAR)    
  ((SELECT 'Latest News' AS NEWS_TYPE,NVL(SUM(NO_OF_VIEWED),0) NO_OF_VIEWS,MONTH_YEAR FROM(
      SELECT NO_OF_VIEWED,TO_CHAR(CREATED_DATE,'MM-YYYY') AS MONTH_YEAR FROM NEWS_LATEST_UR
  
   UNION ALL
      SELECT NO_OF_VIEWED,TO_CHAR(CREATED_DATE,'MM-YYYY')  AS MONTH_YEAR FROM NEWS_LATEST_EN
  ) E WHERE MONTH_YEAR = TO_CHAR(SYSDATE,'MM-YYYY') GROUP BY MONTH_YEAR) 
  </code></pre>