From niall.litchfield@dial.pipex.com Tue, 08 Jul 2003 13:22:19 -0700
From: "Niall Litchfield" <niall.litchfield@dial.pipex.com>
Date: Tue, 08 Jul 2003 13:22:19 -0700
Subject: RE: Windohs - monthly at job
Message-ID: <F001.005C3E53.20030708130948@fatcity.com>
MIME-Version: 1.0
Content-Type: text/plain
Title: Message



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>