Job interval

Dúvidas, dicas e truques de PL/SQL. Aqui também vão assuntos relacionados a pacotes, triggers, funções, Java-Stored Procedures, etc
  

Poston Thu, 13 Aug 2009 5:30 pm

Good afternoon guys how do I get the job runs every day 20 of the month?

Thanks
Nadia Teles
Location: São Caetano do Sul

Poston Fri, 14 Aug 2009 2:09 pm

Nadia all good??? Are you creating the Job by SQL Navigator?

Abraçosss
flebrao
Location: Santa Bárbara D'Oeste

Sua vida É o que você É!!!!

Poston Fri, 14 Aug 2009 2:28 pm

of a read on this topic.

viewtopic.php?t=471
RodrigoValentim
Location: Salvador - BA

Rodrigo Valentim
Analista de Sistemas
Oracle Developer

Campanha: Faça uma pesquisa antes de perguntar!!!

Poston Sat, 05 Sep 2009 12:01 am

Hi, see example below: Interval: Trunc (Sysdate) +1 What: IF (To_Char (Sysdate, ' DD ') = 20) Then < Statement > End IF;

Abcs!
tapenatti
Location: Rib. Preto / SP


  • See also
    Replies
    Views
    Last Post


Return to PL/SQL

Who is online

Users browsing this forum: No registered users and 5 guests