Can you create a shortcut to a task scheduled on a Server and trigger processes on events

I have a staff member who needs a simple process that allows her from her XP Pro machine to be able to click a button or shortcut that will point to a task on a Windows 2008 machine that will allow her to kick off an "End of Day Backup" on an MS Access Database we built for her.

Is that possible to do with a shortcut or some other kind of scheduled task from within XP Pro SP3 to the windows 2008 server?
Once that is clicked the 4 batch files which I have already built individually then kick off in succession.
1.) backup access database
2.) repair and compact database
3.) zip up file to a smaller format
4.) FTP file up to a secured server offsite.

Can anyone tell me how these are done in steps and if they can be done. Thank you very much.
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

TripyreCommented:
remove the user from the process and setup the task on the server. It would require Access on the server, but would prevent user error/forgetfulness.
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
The task is actually set up on the server the problem is and I must have explained it poorly is that she is on an XP Pro SP3 machine and she will probably have problems with remote desktop and I am sure forget to log out of the server.
So I thought maybe there was a way to create a shortcut to the actual task over the network from the Win2008Server to her XP machine or can I create a task on her XP machine that will trigger the backup on the Server.

Consequently I need to figure out what to use and do to trigger the other processes listed above any thoughts on that one to? I have never triggered events one after the other only in a timed environment. Like this Backup 5pm, Repair 5:15pm, Zip 5:30 and FTP 5:45. How do you set up events that depend on a series of processes happening like above?
0
TripyreCommented:
why not just schedule the task on the server? no user interaction required no shortcut needed.  Not sure why she would need to remote to the server if the backup is a scheduled task. Create 4 seperate jobs and just leave time in between of however long it takes for each process.
0
Problems using Powershell and Active Directory?

Managing Active Directory does not always have to be complicated.  If you are spending more time trying instead of doing, then it's time to look at something else. For nearly 20 years, AD admins around the world have used one tool for day-to-day AD management: Hyena. Discover why

RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
We tried that but we are a production facility that makes high quality pet foods for the major pet food manufacturers and what we cannot predict is when we can be shut down. Our small but growing Access system has to be closed so that we can run the backup at least. It takes between 1 to two minutes to run. Unfortunately there are so many parts of the plant and so many using our custom system that we cannot seem to get everyone to remember to get out at a certain time. We have a variety of issues that make that difficult. So I thought the best thing to do to simplify this is have her at the end of day when invoices are complete and trucks have shipped to call all managers shippers and receiving personnel to log out for 5 minutes that we can get a consistent cooperation. Then she clicks a button and goes home. They log back in 5 mins back running production. Every time I have tried to set a task on the server for a designated time some "Bone Head" still talking to his girlfriend forgets to log out and nothing gets backed up.
Even at the end of an office day the 2 shift is has already begun and in full production. (we run 24/7/365 and yes Christmas.) Dogs and cats never stop eating either apparently. I hope that clears it up.
Any thoughts on what I can do a shortcut from server to her desktop, a Scheduled Task run from her machine pointing to the server or something I have not thought of. Please advise and thank you just for being here. You guys are great.
0
TripyreCommented:
you could automate it that all users are kicked out of the database at a certain time, say 12am and then have the backup process run.  Make it a policy that during that time the system would not be available. It is inevitable that someone is going to forget to logout and attached to the system.  By kicking them out and setting a time that the system is down, you will prevent a lot of corruption. Eventually people will get used the "Maintenance Window" and will know that the system is not available during that time.
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
Sorry to be a pain. How do you kick them out of Access? I do not know where that is? In fact I did not now that Access could do that. How would I do that?
0
RUA Volunteer2?Tableau Trainer & Consultant Sales Exec.Author Commented:
There is one drawback to that with our group some English speaking some not. That if they were in the system and they got bumped out they may not understand what happened to the system and either go back and double enter the same information in a new form or leave it unfinished thinking that it is done. Then the next day when offices open the staff get either half a Bill of Lading and everyone on night shift has gone home or two BOLs with partial entry's in some of it.

I wonder if I should post this question and see if I can get the answer to:

Can I create a shortcut from a batch file on the Win2008Server to a user on a XP machine and since it will run as an Administrator on the server will the Client need to have that right to run?
Or
Can I create a shortcut from a task in Task Scheduler on the Win2008Server to an XP machine and since it will run as an Administrator on the server will the Client  need to have that right to run?
Or
Can I create a task on the XP machine that will point either to the actual batch file on the Server or to the FTP upload task on the Server to get the process to run?
0
TripyreCommented:
This looks like it does everything you want except for the FTP
http://news.office-watch.com/t/n.aspx?articleid=1093&zoneid=30
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Programming

From novice to tech pro — start learning today.