AT command

[lee]

Hi,
How do i use the 'AT' command ? I want to run a script at a particular time after logging into sql plus.

Please help.

Thanks.

[Oracledba8]

There is no word at understandable to SQL...

Here is that is used

@ScriptPathandFullname Better to give the File extension as well

Hope this is what you need.
Thanks

[anuragmin]

I think what lee means is that he wants to schedule a job which will log into sqlplus and execute some jobs.

AT is a NT/2000 command.

The synax is
at [\\computername] time [/interactive] [/every:date[,...] | /next:date[,...]] command

Hope this helps you.

Thanks
Anurag

[chrisrlong]

AT is the job scheduler provided by NT.

Type AT /? at the command prompt to get a list and description of the parameters.

- Chris

[GARYM]

Take the easy way and use winat and use the GUI for setting the scheduled command.



Gary

[lee]

Thanks a lot for all your help everybody but I tried to use this command:
at 16:00 "schemas.bat"


The file schemas.bat contains the following:

plus80w.exe xa_qc3/abc@infr x:\oracle\cb\schema_report


Please let me know what modification do I have to make?

Thanks.

[chrisrlong]

You need to provide a path to the file.

You must know where the AT command is running from. It is probably in C:\WINNT\System32. So, you will need to point to where the file is on the machine if it is not in that directory.

For example:

AT 16:00 "C:\AT_Jobs\Schemas.bat"

HTH,

- Chris

[lee]

I did not understand for which file do I have to specify the path.

Please let me know in detail with the full 'AT' command.

Also, is the batch file okay? Do I have to put '@' before 'x:\oracle\cb\schema_report?' Please let me know.\

Thanks.

[lee]

Please let me know.

[anuragmin]

You do have to put an @ before 'x:\oracle\cb\schema_report