Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: Windohs - monthly at job

RE: Windohs - monthly at job

From: Branimir Petrovic <BranimirP_at_cpas.com>
Date: Tue, 08 Jul 2003 09:55:46 -0700
Message-ID: <F001.005C3DFF.20030708094434@fatcity.com>

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 
C:\myJob.bat

<SPAN

class=231441616-08072003>C:>at <A
href="file://%25ComputerName%25/">\\%ComputerName%<FONT

color=#0000ff> 23:00 /every:1<SPAN 
class=231441616-08072003>5 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
    Received on Tue Jul 08 2003 - 11:55:46 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US