AT Scheduler

All posts relating to Oracle development.

Moderator: Tim...

AT Scheduler

Postby shrinika » Tue Feb 09, 2010 4:11 am

Tim, I understand that, this is not a right forum to submit. I appologies. I do want to submit windows jobs in windows XP.. How do i use AT scheduler to schedule the job. I googled the AT scheduler and i am not finding any proper info. Here i do not want to submit the job by using windows scheduler due to some privileges issue. Please let me know if have any info...

Regards
Shrinika
shrinika
Senior Member
 
Posts: 165
Joined: Fri Jun 13, 2008 3:18 pm

Re: AT Scheduler

Postby Tim... » Tue Feb 09, 2010 9:06 am

Hi.

If you type "AT /?" at the command prompts you should get the usage like this:

Code: Select all
AT [\\computername] [ [id] [/DELETE] | /DELETE [/YES]]
AT [\\computername] time [/INTERACTIVE]
    [ /EVERY:date[,...] | /NEXT:date[,...]] "command"

\\computername     Specifies a remote computer. Commands are scheduled on the
                   local computer if this parameter is omitted.
id                 Is an identification number assigned to a scheduled
                   command.
/delete            Cancels a scheduled command. If id is omitted, all the
                   scheduled commands on the computer are canceled.
/yes               Used with cancel all jobs command when no further
                   confirmation is desired.
time               Specifies the time when command is to run.
/interactive       Allows the job to interact with the desktop of the user
                   who is logged on at the time the job runs.
/every:date[,...]  Runs the command on each specified day(s) of the week or
                   month. If date is omitted, the current day of the month
                   is assumed.
/next:date[,...]   Runs the specified command on the next occurrence of the
                   day (for example, next Thursday).  If date is omitted, the
                   current day of the month is assumed.
"command"          Is the Windows NT command, or batch program to be run.


The first example schedules a job which runs the c:\jobs\MyJob.bat script at 9:00 pm on Mondays, Tuesdays, Thurdays and Fridays. The second example schedules a job that runs the script at 6:00 am on the next 20th of the month.

Code: Select all
C:> at 21:00 /every:m,t,th,f "c:\jobs\MyJob.bat"
Added a new job with job ID = 1

C:> at 6:00 /next:20 "c:\jobs\MyJob.bat"
Added a new job with job ID = 2


The current list of jobs can be displayed by issuing the at command with no parameters:

Code: Select all
C:\>at
Status ID   Day                     Time          Command Line
-------------------------------------------------------------------------------
        1   Each M T Th F           21:00 PM      c:\jobs\MyJob.bat
        2   Next 20                 06:00 AM      c:\jobs\MyJob.bat

C:\>


Jobs can be deleted using the /delete option like:

Code: Select all
C:\>at 1 /delete

C:\>at 2 /delete

C:\>at
There are no entries in the list.

C:\>


That is about all I know about AT.

Oh, but the way, you need to make sure the service is on.

Code: Select all
net stop "Task Scheduler"
net start "Task Scheduler"
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 12432
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK

Re: AT Scheduler

Postby shrinika » Tue Feb 09, 2010 6:10 pm

Tim, Thank you!!!. Your answer is very detail and helpful. I highly appreciate your answer.
shrinika
Senior Member
 
Posts: 165
Joined: Fri Jun 13, 2008 3:18 pm

Re: AT Scheduler

Postby Tim... » Tue Feb 09, 2010 6:23 pm

:)
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog
Tim...
Site Admin
 
Posts: 12432
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK


Return to Oracle Development

Who is online

Users browsing this forum: No registered users and 5 guests