473,379 Members | 1,191 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,379 software developers and data experts.

Scheduled trigger of an ASP page?

Apologies if this is not the best group for this question. Please point me
elsewhere if required.

I have access to an ASP based system where a supervisor has to periodically
"press the button" to generate a list based on a database held behind the
webserver. Unfortunately, people being what they are, this is sometimes
forgotten so I'm investigating whether this can be automated.

My hands are tied slightly in that I can access the webpages themselves,
most of which contain ASP, and I can run something on the surpervisor's PC,
for example via "Task Scheduler" to download pages. But what tool should I
use? I can't see any way of triggering Internet Explorer is "automated
mode" to just trigger the page so is there some tool specifically designed
for this job?

To be clear, I can split out the "button pushed" processing into an ASP
based page that has no output and just creates the list (which is then
e-mailed around). What I need though, seems to be to access this "no output
page" as if I attempted to read it using Internet Explorer - I think!

Thanks for any suggestions,
Paul DS.

--
Please remove the "x-" if replying to sender.
Jul 19 '05 #1
3 1318
I don't think it even can be done. Triggers are usualy made in SQL server.

Sven

"Paul D.Smith" <pa**********@x-hotmail.com> skrev i meddelandet
news:41***********************@reading.news.pipex. net...
Apologies if this is not the best group for this question. Please point me elsewhere if required.

I have access to an ASP based system where a supervisor has to periodically "press the button" to generate a list based on a database held behind the
webserver. Unfortunately, people being what they are, this is sometimes
forgotten so I'm investigating whether this can be automated.

My hands are tied slightly in that I can access the webpages themselves,
most of which contain ASP, and I can run something on the surpervisor's PC, for example via "Task Scheduler" to download pages. But what tool should I use? I can't see any way of triggering Internet Explorer is "automated
mode" to just trigger the page so is there some tool specifically designed
for this job?

To be clear, I can split out the "button pushed" processing into an ASP
based page that has no output and just creates the list (which is then
e-mailed around). What I need though, seems to be to access this "no output page" as if I attempted to read it using Internet Explorer - I think!

Thanks for any suggestions,
Paul DS.

--
Please remove the "x-" if replying to sender.

Jul 19 '05 #2
AJ
If you want to automate tasks that are performed in ASP scripts the
traditional way to do this is to copy the ASP code into a new text file
with a .VBS extension. You will need to make a few additional changes to
it such as changing any reference to "Server." to "Wscript." and
removing any references to the Request and Resposne objects as well.

Take a look at the following and see if this will suit your needs.

http://support.microsoft.com/?kbid=188135

If so, VBS scripts can be executed as scheduled tasks just like any
program except you dont need to run IE to do it. You just execute the
VBS script its self.

*** Sent via WindowsHostList http://www.windowshostlist.com ***
Jul 19 '05 #3
"AJ" <aa***@visualwarp.com> wrote in message
news:41**********************@news.newsgroups.ws.. .
If you want to automate tasks that are performed in ASP scripts the
traditional way to do this is to copy the ASP code into a new text file
with a .VBS extension. You will need to make a few additional changes to
it such as changing any reference to "Server." to "Wscript." and
removing any references to the Request and Resposne objects as well.

Take a look at the following and see if this will suit your needs.

http://support.microsoft.com/?kbid=188135

If so, VBS scripts can be executed as scheduled tasks just like any
program except you dont need to run IE to do it. You just execute the
VBS script its self.

*** Sent via WindowsHostList http://www.windowshostlist.com ***


Sounds like what I need.

Thanks,
Paul DS.
Jul 19 '05 #4

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
by: David Hickman | last post by:
Hi all, I have a website that I am building in PHP that I would like to send e-mails to users every 2 days to inform of new updates. I know how to trigger the sending of e-mails if a user...
4
by: Colin Steadman | last post by:
We have a number of scheduled tasks on our IIS server that run daily at some point during the early morning. These tasks run as a specific user that has the correct permissions to perform whatever...
2
by: KK | last post by:
Can a ASP page trigger a windows job? Any ideas? KK
10
by: Heiko Pliefke | last post by:
Hi NG! I wrote a stored procedure which at first deletes 100.000 rows and then inserts 100.000 new rows. There is a huge difference between executing this SP in the query-analyzer (runtime...
6
by: John Bowman | last post by:
Hi, I have a C# app that needs to launch the "Add Scheduled Tasks" wizard found in the control panel "Scheduled Tasks" applet. I realize that this "applet" really just opens the tasks folder,...
11
by: Max | last post by:
I'm writing a program that needs to be able to create custom .job files and add them to the scheduled tasks folder. What I'd like to know is, what is the format of a .job file and how do I go about...
3
by: Mike | last post by:
Hi all, In my recent project (using ASP.NET 2.0 and MSSQL), I need to scheduled a certain operation to be executed, for example, on beginning of a month. Is there anyway to do this on...
3
by: Steve | last post by:
Here is what I want to do. Currently I have to log into 30 servers every morning and see if all the jobs under 'scheduled tasks' ran. Is there a way from .NET to read that directory for the selected...
1
by: dmorand | last post by:
I have a scheduled task that I setup in the CF administrator. It calls a page which runs some queries and inserts some data into tables. I checked the output file, and I'm getting this error: ...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.