Special needs, regularly run your ASP file

zhaozj2021-02-16  85

At a certain time, I want to run a ASP file to execute a task, such as a factory to collect all the meter readings at 9 o'clock in the morning, and of course it is to connect to each electric meter through in SQL. We now use A ASP file focuses the readings of the IN SQL to MS SQL.

There are many ways to run the ASP file in the timing you see, but I am now talking about a simple way, using a planned task to make a simple implementation.

First, you have to write a JS or VBS file to call all your executed ASP. Below is the code of the JS and VBS files, you can choose one, the execution effect is the same.

VBS code ------------------------- 'Code by Xiaohi Aston314@sohu.com'create an instance of Iedim IESET IE = CreateObject ("InternetExplorer .Application ")

'Run your URL

IE.NAVIGATE ("http://www.blueidea.com/") ie.visible = 1

'Clean Up ... set i = nothing ---------------------------------

You can take any name, but if you must be VBS, here we name Do.vbs.

JS code --------------------------- // Code by Xiaohe Aston314@sohu.com/ Create the Html Message to Display.var HTML = ""; html = " Run window </ title> </ head> <body>"; html = "<font face = verdana> </ font>"; HTML = "</ body> </ html>";</p> <p>// Create Internet Explorer Objectie = New ActiveXObject ("InternetExplorer.Application);</p> <p>// define how the window shopie.LEFT = 50; IE.TOP = 50; IE.HEIGHT = 510; IE.Width = 470; IE.Menubar = 0; IE.Toolbar = 0;</p> <p>// set the browser to a blank pageie.navigate ("http://www.blueidea.com/");</p> <p>// Show the browserie.visible = 1;</p> <p>// Open a stream and write data .// ie.document.open; // ie.document.write (html); // ie.document.close; -------------- ----------------------</p> <p>You can also take any name, but if you must be JS, here we name DO.JS.</p> <p>There is no explanation of the code in the file here.</p> <p>Just put all the http://www.blueidea.com in the above file to replace the URL address of the ASP file you want to perform. Here is the URL address, not an absolute address.</p> <p>Then open the Windows task plan, select the location of the Do.js or the DO.vbs file like any executable, set the execution time, etc., and then determine it. Then this ASP file can be run by the task plan, simple.</p> <p>Just as the beginning, the task plan can execute this ASP file at 9 o'clock in the morning, collect the reading of the meter into MS SQL.</p></div><div class="text-center mt-3 text-grey"> 转载请注明原文地址:https://www.9cbs.com/read-13670.html</div><div class="plugin d-flex justify-content-center mt-3"></div><hr><div class="row"><div class="col-lg-12 text-muted mt-2"><i class="icon-tags mr-2"></i><span class="badge border border-secondary mr-2"><h2 class="h6 mb-0 small"><a class="text-secondary" href="tag-2.html">9cbs</a></h2></span></div></div></div></div><div class="card card-postlist border-white shadow"><div class="card-body"><div class="card-title"><div class="d-flex justify-content-between"><div><b>New Post</b>(<span class="posts">0</span>) </div><div></div></div></div><ul class="postlist list-unstyled"> </ul></div></div><div class="d-none threadlist"><input type="checkbox" name="modtid" value="13670" checked /></div></div></div></div></div><footer class="text-muted small bg-dark py-4 mt-3" id="footer"><div class="container"><div class="row"><div class="col">CopyRight © 2020 All Rights Reserved </div><div class="col text-right">Processed: <b>0.034</b>, SQL: <b>9</b></div></div></div></footer><script src="./lang/en-us/lang.js?2.2.0"></script><script src="view/js/jquery.min.js?2.2.0"></script><script src="view/js/popper.min.js?2.2.0"></script><script src="view/js/bootstrap.min.js?2.2.0"></script><script src="view/js/xiuno.js?2.2.0"></script><script src="view/js/bootstrap-plugin.js?2.2.0"></script><script src="view/js/async.min.js?2.2.0"></script><script src="view/js/form.js?2.2.0"></script><script> var debug = DEBUG = 0; var url_rewrite_on = 1; var url_path = './'; var forumarr = {"1":"Tech"}; var fid = 1; var uid = 0; var gid = 0; xn.options.water_image_url = 'view/img/water-small.png'; </script><script src="view/js/wellcms.js?2.2.0"></script><a class="scroll-to-top rounded" href="javascript:void(0);"><i class="icon-angle-up"></i></a><a class="scroll-to-bottom rounded" href="javascript:void(0);" style="display: inline;"><i class="icon-angle-down"></i></a></body></html><script> var forum_url = 'list-1.html'; var safe_token = 'XusmaQvXxmr5P8VPpTDFx7IfD6ret4ck5gUBZS2GT_2B2Vg8_2Fx0V05pzU9JxniWbROUGYKqtutSHMpE_2Fjt'; var body = $('body'); body.on('submit', '#form', function() { var jthis = $(this); var jsubmit = jthis.find('#submit'); jthis.reset(); jsubmit.button('loading'); var postdata = jthis.serializeObject(); $.xpost(jthis.attr('action'), postdata, function(code, message) { if(code == 0) { location.reload(); } else { $.alert(message); jsubmit.button('reset'); } }); return false; }); function resize_image() { var jmessagelist = $('div.message'); var first_width = jmessagelist.width(); jmessagelist.each(function() { var jdiv = $(this); var maxwidth = jdiv.attr('isfirst') ? first_width : jdiv.width(); var jmessage_width = Math.min(jdiv.width(), maxwidth); jdiv.find('img, embed, iframe, video').each(function() { var jimg = $(this); var img_width = this.org_width; var img_height = this.org_height; if(!img_width) { var img_width = jimg.attr('width'); var img_height = jimg.attr('height'); this.org_width = img_width; this.org_height = img_height; } if(img_width > jmessage_width) { if(this.tagName == 'IMG') { jimg.width(jmessage_width); jimg.css('height', 'auto'); jimg.css('cursor', 'pointer'); jimg.on('click', function() { }); } else { jimg.width(jmessage_width); var height = (img_height / img_width) * jimg.width(); jimg.height(height); } } }); }); } function resize_table() { $('div.message').each(function() { var jdiv = $(this); jdiv.find('table').addClass('table').wrap('<div class="table-responsive"></div>'); }); } $(function() { resize_image(); resize_table(); $(window).on('resize', resize_image); }); var jmessage = $('#message'); jmessage.on('focus', function() {if(jmessage.t) { clearTimeout(jmessage.t); jmessage.t = null; } jmessage.css('height', '6rem'); }); jmessage.on('blur', function() {jmessage.t = setTimeout(function() { jmessage.css('height', '2.5rem');}, 1000); }); $('#nav li[data-active="fid-1"]').addClass('active'); </script>