the AT doesn't works completely

[Acosta]

Hello,
I´m trying to schedule some tasks with AT command. When I schedule a batch file with a system program in it. It works perfectly, when I schedule another batch file with other command "Progress" the task doesn't work.

I would like to shutdown the databases so I can make a backup.

Any Ideas?
Thanks!

 

[Acosta]

Well, I change the bat file to the winnt\system32 folder and when I schedule it... it runs but then I want to access a drive e: and it tells me "Access denied"
I'm scheduling with the admin profile which has privileges to access drive e:
Any ideas!
Thanks!

 

[GregBVH]

I have run into the same problem. When ever you attempt to use the at command to refrence a non local drive you recive access denied even when logged on with full rights. I also tried starting the Scheduler Service as administrator and It gave the same accessed denied errors when trying to change to a network map with a *.bat file. Running the bat file from a dos prompt on that same computer logged in the same way works fine however.

If anyone has found a way around this other then running the AT command on the local machine you want to make changes to please let me know

 

[lordhuh]

i think (dont quote me on this) that with ie 5.5(probably earlier too) they redid the at stuff. there will be a new controll panel like folder (you know there will be printers, controll pannel, and now schedular) supports old at commands set up, but seems to be reworked cause at dosnt see the ones u make with it (i dont know if it supports the networked drives or not). if you really need this and can stand a reboot i would suggest to just give it a shot.

hope that helps.

ps if you install it and cant reboot right then. put in an at command to reboot the server like that night. on the resource cd there is a shutdown.exe /L /R /Y will reboot. i can send you the file if you want. Karl Pietri
lordhuh.pota.to

 

[OldSkoolSkater]

Hello all,
The answer is as follows:
When you use commands from a DOS prompt and are logged on as administrator, admin rights apply and you can access non-local drives.
The AT command however, uses the system account (not the administrator account) and as a result the access rights are restricted.
You could put the net use command into your batch file and log on as administrator to give you the necessary access to the drives.
You could also change the permissions of the drive to give the sytem account full access.
Let me know how you get on......

 

[Guest_imported]

SnowDude,

Will your suggestion work on a workgroup rather than a domain?

Thanks in advance.

 

[GregBVH]

The AT command still uses system Account premisions even if you started the scheduler service with the administrator account for startup instead of letting it use the system account?

 

[Guest_imported]

Greg,

That seems to be the case. If you use the task scheduler to create the task, it is created under the login account.

 

[Acosta]

What type of permissions should I give the SYSTEM Account to shutdown the databases?
Where can I read about the net use commands to log on as SnowDude said?

 

[Guest_imported]

How do you pass login information using 'net use'?

 

[Acosta]

I gave the system account full access to the drive where I have the databases... and run the bat file that is in the winnt\system32 folder it runs but I get the same access denied.
The other thing to do as SnowDude said is log using net use commands but HOW?

 

[lordhuh]

net stop
will log you off
net start
will start network services and ask for a username/password. (on 9x bet it is same on nt but i dont have any nt that i can test it on that isnt critical) Karl Pietri
lordhuh.pota.to

 

[OldSkoolSkater]

Hello Folks
If you are still wondering how to log on with Net Use command, here goes:
Net Use x: \\comp\c$ /user:domain\administrator

X - is the drive letter you assign
\\comp\c$ - is the UNC path to the share
domain - is your domain name
administrator - is the account name

Remember to add at the end of your batch script:
Net use x: /d

This will disconnect the drive after your commands have run.
Let me know how you get on....

SnowDude