Scheduled jobs

  • Thread starter Thread starter jj
  • Start date Start date
J

jj

Hi ng

I have got a job on a network drive (a database mdb) which should be
activated every night. I have made a scheduled task - where I use my own
username and password on a normal computer. This works fine. But this
solution requires that I am logged on to the computer. I would like a
solution where no one needs to be logged on - as long as the computer is not
shut down, user is only logged off.

I am just a regular user - I am not an administrator. I have read something
about using the AT command but I am not sure how to do that.

My job should run at 05:00 am every day and should activate MyDatabase.mdb.

Can anyone help?

TIA
JJ
 
Info on the At command:
AT

The AT command schedules commands and programs to run on a computer at a specified time and date. The Schedule service must be running to use the AT command.


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.


If you still have problems, perhaps posting to an office.access ng will get the results you need.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375
 
Hi Brian

Thank you for your answer. I have tryied to type the following in a dos
promt command:

AT 05:00 /every:M,T,W,Th,F,S,Su "c:\Mydatabase.mdb"

But I get the error: You used a parameter with an invalid value

what do I wrong?

TIA
JJ


"Brian A." <gonefish'n@afarawaylake> skrev i en meddelelse
Info on the At command:
AT

The AT command schedules commands and programs to run on a computer at a
specified time and date. The Schedule service must be running to use the AT
command.


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.


If you still have problems, perhaps posting to an office.access ng will
get the results you need.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375
 
works fine here verbatim.

--
--------------------------------------------------------------------------------------------------
How to lose a war in Iraq
http://webdiary.com.au/cms/?q=node/1335#comment-48641
=================================================
jj said:
Hi Brian

Thank you for your answer. I have tryied to type the following in a dos
promt command:

AT 05:00 /every:M,T,W,Th,F,S,Su "c:\Mydatabase.mdb"

But I get the error: You used a parameter with an invalid value

what do I wrong?

TIA
JJ


"Brian A." <gonefish'n@afarawaylake> skrev i en meddelelse
Info on the At command:
AT

The AT command schedules commands and programs to run on a computer at a
specified time and date. The Schedule service must be running to use the AT
command.


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.


If you still have problems, perhaps posting to an office.access ng will
get the results you need.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375




jj said:
Hi ng

I have got a job on a network drive (a database mdb) which should be
activated every night. I have made a scheduled task - where I use my own
username and password on a normal computer. This works fine. But this
solution requires that I am logged on to the computer. I would like a
solution where no one needs to be logged on - as long as the computer is
not
shut down, user is only logged off.

I am just a regular user - I am not an administrator. I have read
something
about using the AT command but I am not sure how to do that.

My job should run at 05:00 am every day and should activate
MyDatabase.mdb.

Can anyone help?

TIA
JJ
Click to expand...
Click to expand...
 
hmm - and it doesn't matter in which folder I am standing when I write it in
the dos-prompt right?

/jj
"David Candy" <.> skrev i en meddelelse
works fine here verbatim.

--
--------------------------------------------------------------------------------------------------
How to lose a war in Iraq
http://webdiary.com.au/cms/?q=node/1335#comment-48641
=================================================
jj said:
Hi Brian

Thank you for your answer. I have tryied to type the following in a dos
promt command:

AT 05:00 /every:M,T,W,Th,F,S,Su "c:\Mydatabase.mdb"

But I get the error: You used a parameter with an invalid value

what do I wrong?

TIA
JJ


"Brian A." <gonefish'n@afarawaylake> skrev i en meddelelse
Info on the At command:
AT

The AT command schedules commands and programs to run on a computer at a
specified time and date. The Schedule service must be running to use the
AT
command.


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.


If you still have problems, perhaps posting to an office.access ng will
get the results you need.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375




jj said:
Hi ng

I have got a job on a network drive (a database mdb) which should be
activated every night. I have made a scheduled task - where I use my own
username and password on a normal computer. This works fine. But this
solution requires that I am logged on to the computer. I would like a
solution where no one needs to be logged on - as long as the computer is
not
shut down, user is only logged off.

I am just a regular user - I am not an administrator. I have read
something
about using the AT command but I am not sure how to do that.

My job should run at 05:00 am every day and should activate
MyDatabase.mdb.

Can anyone help?

TIA
JJ
Click to expand...
Click to expand...
 
I cut and pasted what you typed and it was happy. What happens if you schedule through the UI.

--
--------------------------------------------------------------------------------------------------
How to lose a war in Iraq
http://webdiary.com.au/cms/?q=node/1335#comment-48641
=================================================
jj said:
Hi Brian

Thank you for your answer. I have tryied to type the following in a dos
promt command:

AT 05:00 /every:M,T,W,Th,F,S,Su "c:\Mydatabase.mdb"

But I get the error: You used a parameter with an invalid value

what do I wrong?

TIA
JJ


"Brian A." <gonefish'n@afarawaylake> skrev i en meddelelse
Info on the At command:
AT

The AT command schedules commands and programs to run on a computer at a
specified time and date. The Schedule service must be running to use the AT
command.


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.


If you still have problems, perhaps posting to an office.access ng will
get the results you need.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375




jj said:
Hi ng

I have got a job on a network drive (a database mdb) which should be
activated every night. I have made a scheduled task - where I use my own
username and password on a normal computer. This works fine. But this
solution requires that I am logged on to the computer. I would like a
solution where no one needs to be logged on - as long as the computer is
not
shut down, user is only logged off.

I am just a regular user - I am not an administrator. I have read
something
about using the AT command but I am not sure how to do that.

My job should run at 05:00 am every day and should activate
MyDatabase.mdb.

Can anyone help?

TIA
JJ
Click to expand...
Click to expand...
 
C:\Program Files\Support Tools>AT 05:00 /every:M,T,W,Th,F,S,Su "c:\Mydatabase.m
db"
Added a new job with job ID = 1

--
--------------------------------------------------------------------------------------------------
How to lose a war in Iraq
http://webdiary.com.au/cms/?q=node/1335#comment-48641
=================================================
jj said:
hmm - and it doesn't matter in which folder I am standing when I write it in
the dos-prompt right?

/jj
"David Candy" <.> skrev i en meddelelse
works fine here verbatim.

--
--------------------------------------------------------------------------------------------------
How to lose a war in Iraq
http://webdiary.com.au/cms/?q=node/1335#comment-48641
=================================================
jj said:
Hi Brian

Thank you for your answer. I have tryied to type the following in a dos
promt command:

AT 05:00 /every:M,T,W,Th,F,S,Su "c:\Mydatabase.mdb"

But I get the error: You used a parameter with an invalid value

what do I wrong?

TIA
JJ


"Brian A." <gonefish'n@afarawaylake> skrev i en meddelelse
Info on the At command:
AT

The AT command schedules commands and programs to run on a computer at a
specified time and date. The Schedule service must be running to use the
AT
command.


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.


If you still have problems, perhaps posting to an office.access ng will
get the results you need.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375




jj said:
Hi ng

I have got a job on a network drive (a database mdb) which should be
activated every night. I have made a scheduled task - where I use my own
username and password on a normal computer. This works fine. But this
solution requires that I am logged on to the computer. I would like a
solution where no one needs to be logged on - as long as the computer is
not
shut down, user is only logged off.

I am just a regular user - I am not an administrator. I have read
something
about using the AT command but I am not sure how to do that.

My job should run at 05:00 am every day and should activate
MyDatabase.mdb.

Can anyone help?

TIA
JJ
Click to expand...
Click to expand...
Click to expand...
 
David,

I tried both at the command prompt and using the scheduler. The command prompt added a job w/ID and the scheduler appeared to be fine as well. However, they failed to run at the specified time.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375




"David Candy" <.> wrote in message I cut and pasted what you typed and it was happy. What happens if you schedule through the UI.

--
--------------------------------------------------------------------------------------------------
How to lose a war in Iraq
http://webdiary.com.au/cms/?q=node/1335#comment-48641
=================================================
jj said:
Hi Brian

Thank you for your answer. I have tryied to type the following in a dos
promt command:

AT 05:00 /every:M,T,W,Th,F,S,Su "c:\Mydatabase.mdb"

But I get the error: You used a parameter with an invalid value

what do I wrong?

TIA
JJ


"Brian A." <gonefish'n@afarawaylake> skrev i en meddelelse
Info on the At command:
AT

The AT command schedules commands and programs to run on a computer at a
specified time and date. The Schedule service must be running to use the AT
command.


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.


If you still have problems, perhaps posting to an office.access ng will
get the results you need.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375




jj said:
Hi ng

I have got a job on a network drive (a database mdb) which should be
activated every night. I have made a scheduled task - where I use my own
username and password on a normal computer. This works fine. But this
solution requires that I am logged on to the computer. I would like a
solution where no one needs to be logged on - as long as the computer is
not
shut down, user is only logged off.

I am just a regular user - I am not an administrator. I have read
something
about using the AT command but I am not sure how to do that.

My job should run at 05:00 am every day and should activate
MyDatabase.mdb.

Can anyone help?

TIA
JJ
Click to expand...
Click to expand...
 
Hi Guys

Have been out traveling for a few days!

I have the same problem as you Brian - When I schedule a plain Bat command
file - then it works perfectly - but not when I try to execute the MSaccess
database.

Any help would be appreciated!
JJ
"Brian A." <gonefish'n@afarawaylake> skrev i en meddelelse
David,

I tried both at the command prompt and using the scheduler. The command
prompt added a job w/ID and the scheduler appeared to be fine as well.
However, they failed to run at the specified time.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375




"David Candy" <.> wrote in message
I cut and pasted what you typed and it was happy. What happens if you
schedule through the UI.

--
--------------------------------------------------------------------------------------------------
How to lose a war in Iraq
http://webdiary.com.au/cms/?q=node/1335#comment-48641
=================================================
jj said:
Hi Brian

Thank you for your answer. I have tryied to type the following in a dos
promt command:

AT 05:00 /every:M,T,W,Th,F,S,Su "c:\Mydatabase.mdb"

But I get the error: You used a parameter with an invalid value

what do I wrong?

TIA
JJ


"Brian A." <gonefish'n@afarawaylake> skrev i en meddelelse
Info on the At command:
AT

The AT command schedules commands and programs to run on a computer at a
specified time and date. The Schedule service must be running to use the
AT
command.


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.


If you still have problems, perhaps posting to an office.access ng will
get the results you need.

--

Brian A. Sesko { MS MVP_Shell/User }
Conflicts start where information lacks.
http://basconotw.mvps.org/

Suggested posting do's/don'ts: http://www.dts-l.org/goodpost.htm
How to ask a question: http://support.microsoft.com/kb/555375




jj said:
Hi ng

I have got a job on a network drive (a database mdb) which should be
activated every night. I have made a scheduled task - where I use my own
username and password on a normal computer. This works fine. But this
solution requires that I am logged on to the computer. I would like a
solution where no one needs to be logged on - as long as the computer is
not
shut down, user is only logged off.

I am just a regular user - I am not an administrator. I have read
something
about using the AT command but I am not sure how to do that.

My job should run at 05:00 am every day and should activate
MyDatabase.mdb.

Can anyone help?

TIA
JJ
Click to expand...
Click to expand...
 
Back
Top