RE: Windohs - monthly at job

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Tue, 08 Jul 2003 13:22:19 -0700
Message-ID: <F001.005C3E53.20030708130948@fatcity.com>

Yuk,
how horrible, fortunately there is a GUI for this. <FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2>perhaps we could see an example solution for running eg.sql which consists of "select sysdate from dual; exit;" as against doing the same query with DBMS_JOB on the same schedule. <FONT face=Arial color=#0000ff
size=2> 

Niall  
<FONT face=Arial color=#0000ff
size=2> 
<FONT face=Arial color=#0000ff
size=2> 
<BLOCKQUOTE dir=ltr
style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">   

  <FONT
  face=Tahoma size=2>-----Original Message-----From:   [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of   Boivin, Patrice JSent: 08 July 2003 19:14To:   Multiple recipients of list ORACLE-LSubject: RE: Windohs - monthly   at job
  OK
  now, for fun, schedule through AT a job that will run every fifteen minutes   between 6AM and 8PM on Mondays through Fridays.   <FONT face=Arial color=#0000ff
  size=2> 
  :
  )
  <FONT face=Arial color=#0000ff
  size=2> 
  <FONT face=Arial color=#0000ff
  size=2>Patrice.   

<FONT face=Tahoma

    size=2>-----Original Message-----From: Branimir Petrovic     [mailto:[EMAIL PROTECTED]Sent: Tuesday, July 08, 2003 2:45     PMTo: Multiple recipients of list ORACLE-LSubject: RE:     Windohs - monthly at job
    Jerry,
    t<SPAN
    class=231441616-08072003>o schedule "something" on local or remote     Win2K computer:
<SPAN

    class=231441616-08072003> 
    Simple
    (preferred), non-GUI way:
<SPAN

    class=231441616-08072003>================================

<SPAN

    class=231441616-08072003> 

• Make sure "Task Scheduler" service is running on the target system,
  <SPAN
  class=231441616-08072003> 
• Open MSDOS "box" then:
  <SPAN
  class=231441616-08072003> 
  <SPAN
  class=231441616-08072003>C:>at <A href="file://\\%ComputerName%">\\%ComputerName%<FONT color=#0000ff> 23:00 /every:1 <SPAN class=231441616-08072003> C:<SPAN class=231441616-08072003>\myJob.bat

<SPAN

    class=231441616-08072003>C:>at <A
    href="file://%25ComputerName%25/"><FONT     size=2>\\%ComputerName% 23:00
    /every:15 C:<SPAN
    class=231441616-08072003>\myJob.bat
<SPAN

    class=231441616-08072003> 
    To see
    what's been scheduled:
<SPAN

    class=231441616-08072003> 
<SPAN

    class=231441616-08072003>C:\>atStatus ID  

    Day                     

    Time          Command

    Line-------------------------------------------------------------------------------        

    1   Each

    1                  

    11:00 PM     
    C:\myJob.bat        2  
    Each

    15                 

    11:00 PM     
    C:\myJob.bat
<SPAN

    class=231441616-08072003> 
    Do not
    specify \\%ComputerName% - and the job     is scheduled locally.
    The
    above is also visible from GUI Task Scheduler.
<SPAN

    class=231441616-08072003> 
<SPAN

    class=231441616-08072003> 
    Other
    way (to do the same):
<SPAN

    class=231441616-08072003>==========================

    By
    leveraging WMI (hideously complex & ugly COM object hierarchy) that     Win2K
    comes
    equipped <SPAN
    class=231441616-08072003>with and by using "scripting for 21st     century" the VB Script.
<SPAN

    class=231441616-08072003> 
    For how
    to it (use M$ scripting) do - see the TechNet Script Center<FONT     color=#ffffff>r
<A

    href="http://www.microsoft.com/technet/treeview/default.asp?url="">http://www.microsoft.com/technet/treeview/default.asp?url="">
<SPAN

    class=231441616-08072003> 
    Section
    on "Task Scheduling":
<A

    href="http://www.microsoft.com/technet/treeview/default.asp?url="">http://www.microsoft.com/technet/treeview/default.asp?url="">
<SPAN

    class=231441616-08072003> 
<SPAN

    class=231441616-08072003> 
    Now,
    let's talk abt. virtual pint... ;-)
<SPAN

    class=231441616-08072003> 
<SPAN

    class=231441616-08072003>Branimir
<BLOCKQUOTE dir=ltr

    style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #0000ff 2px solid; MARGIN-RIGHT: 0px">

      <FONT 
      size=2> -----Original 
      Message-----From: Cunningham, Gerald 
      [mailto:[EMAIL PROTECTED]Sent: July 8, 2003 12:39 
      PMTo: Multiple recipients of list ORACLE-LSubject: 
      Windohs - monthly at job
      Hi 
      all,
      <SPAN 
      class=230243915-08072003> 
      Does anybody 
      know the syntax to schedule a monthly "at" job on Windows (2000)? I need 
      to schedule a job for the 1st and 15th every month, and would like to 
      avoid the Task Scheduler GUI.
      <SPAN 
      class=230243915-08072003> 
      A virtual pint 
      o' Guiness (mmmmmm...) for anybody who can help!
      <SPAN 
      class=230243915-08072003> 
      <SPAN 
      class=230243915-08072003>Thanks!
      <SPAN 
      class=230243915-08072003> 
      - 
      Jerry
      <FONT color=#0000ff 

size=2>  Received on Tue Jul 08 2003 - 15:22:19 CDT