Yuk,
how horrible, fortunately there is a GUI for this.
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.
Niall
-----Original Message-----
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Boivin, Patrice J
Sent: 08 July 2003 19:14
To: Multiple recipients of list ORACLE-L
Subject: RE: Windohs - monthly at jobOK now, for fun, schedule through AT a job that will run every fifteen minutes between 6AM and 8PM on Mondays through Fridays.: )Patrice.-----Original Message-----
From: Branimir Petrovic [mailto:[EMAIL PROTECTED]
Sent: Tuesday, July 08, 2003 2:45 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Windohs - monthly at jobJerry, to schedule "something" on local or remote Win2K computer:Simple (preferred), non-GUI way:================================- Make sure "Task Scheduler" service is running on the target system,- Open MSDOS "box" then:To see what's been scheduled:C:\>at
Status ID Day Time Command Line
-------------------------------------------------------------------------------
1 Each 1 11:00 PM C:\myJob.bat
2 Each 15 11:00 PM C:\myJob.batDo not specify \\%ComputerName% - and the job is scheduled locally.The above is also visible from GUI Task Scheduler.Other way (to do the same):==========================By leveraging WMI (hideously complex & ugly COM object hierarchy) that Win2Kcomes equipped with and by using "scripting for 21st century" the VB Script.For how to it (use M$ scripting) do - see the TechNet Script CenterrSection on "Task Scheduling":Now, let's talk abt. virtual pint... ;-)Branimir-----Original Message-----
From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]
Sent: July 8, 2003 12:39 PM
To: Multiple recipients of list ORACLE-L
Subject: Windohs - monthly at jobHi all,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.A virtual pint o' Guiness (mmmmmm...) for anybody who can help!Thanks!- Jerry