mysql - How to execute PowerShell script on Task Scheduler? -

-

I'm trying to execute my PowerShell script every 5 minutes to run. I tried to use Windows 7 Task Scheduler to run it but instead it opens my script on Notepad and does not include anything in my database

Below is my PowerHail V-2.0 script I do not believe that I have something wrong with my code (which I suspect) or there is no way that I can include it in my script to run it every 5 minutes, which Runs from 9 a.m. to 9 p.m.

Here's how I've scheduled it: 

  Normal -------- Run only when the user is logged on the trigger - ------ Trigger: every day at 8h56am - Description: After every trigger, every 5 minutes again indefinable status: active actions ------- Action: Start the details of a program: Path to the script

Thanks in advance! POWERSHELL (Excluding connection): 

  function ping_getUser {# Get online information about local hard drives only when you are online at the computer {$ workstation_list $ workstation in foreign currency ) {$ Command = $ connection.CreateCommand (); $ Order Connection = $ connection; $ Command.CommandText = "Include workstation_assored (username, hostname, online) values ​​(@ username, @ hostname, @ position)"; ### =============================================== Values ​​assigned as ============== ### parameters ### ===================== == ======================================= $ hostname = $ workstation; $ Test_ping = Test-Connection -CaptainName Hostname -Cora1-AreationCheckLinkIntroduction; $ Position = [bowl] (test-connection $ hostname -quiet-count 1-index silentlycontent); #if get TRUE user name if ($ test_ping) {TRY {$ username = (Get-WMIObject -ComputerName $ hostname-Class Win32_ComputerSystem -ErrorAction stop | Select-object -ExpandProperty username); } Catch {Write-host "caught exception" - Front color red; Write - host "$ _" - red color red; } TRY {if ($ test_ping- and $ username) {$ username = $ username.split ("\"); $ Username = $ username [1]; Do not make $ Username; }} CAT {Write-host "Captured Exception" -Fast Color Red; Write - host "$ _" - red color red; } # If ping succeeds but no user is logged ($ test_ping- and -not $ username) # -eq "" {$ username = "no user"; }} #end if #if ping is not there, then the name of username is correct and for the position Falsei elseif (! $ Test_ping) {$ username = [DBNull] :: Value; } # And otherwise ### =========================================== ==================### Assign parameters with the appropriate standards ### =================== == ======================================== $ command.Parameters.Add (" User name ", $ username). Out-null $ command Parameter. Add ("hostname", $ hostname). Out-null $ command Parameter. Add ("@ position", $ position). Out-null ### ============================================ =================### Execute the command query ### ======================= ==================================== TRY {$ command.ExecuteNonQuery () | Out of naught; Write - host "successfully entered database"; } Catch {Write-host "caught exception" - Front color red; Write - host "$ _" - red color red; } ### ============================================== ===============### Clear parameter value ### ================================== =================================== $ command.Dispose () $ hostname = ""; $ Username = ""; $ Position = ""; $ Test_ping = ""; } Try #end} #Chat for each loop {Write-host "Exception caught" -AfmanCollar Red; Write - host "$ _" - red color red; } # $ Connection capture Stop it (); # Ping_test function ping_getUser #execute function

Your scheduled task to powershell Exe should be called from a script file passed as an argument. 

  powershell.exe -file c: \ path_to_your_script \ script.ps1

The user under which executes the permissions required to execute scripts in the script All actions


Comments

Post a Comment

Popular posts from this blog

Active Directory Authenticated Proxy Server with Squid or CNTLM -

-
I need to configure a proxy server for a local network that authenticates with Active Directory and gives me access The control list enables you to configure the domain groups within AD. I am using: Static with Squid 2.7: Windows 2008 Server R2 I have followed this guide here: The proxy does not currently ask for any Active Directory accounts, as soon as I add the following lines, it starts denying this connection: ACL localnet proxy_auth Required src 192.168. 0.0 / 24 http_access permission localname This is my squid.conf: pastebin.com/ERuKtirc I see logs and 'none' or 'direct' L It comes together TCP_DENIED message 1415014073.069 1 192.168.0.63 TCP_DENIED / 407/1904 Received / -. None / - Text / html 1415014073.07 9 4 192.168.0.63 TCP_DENIED / 407 2304 Received / - None / - Text / html 1415014073.084 2 192.168.0.63 TCPDAD / 407 1904 Received / - None - - Text / html itemprop = "text"> This proxy returns a 407 request with a browse...
Read more

java - Can't add JTree to JPanel of a JInternalFrame -

-
Image
There are two panels in my JInternalframe. I want to add TopPanel to Jtree to nominate another. But I can not add Jaitari to the top of the panel. Please help me in this piece of code: DefaultMutableTreeNode root = new DefaultMutableTreeNode ("deck"); DefaultMutableTreeNode Item Clubs = New DefaultMutableTreeNode ("Club"); AddAllCard (itemClubs); Root.add (itemClubs); DefaultMutableTreeNode item = New DefaultMutableTreeNode ("Diamonds"); AddAllCard (itemDiamonds); Root.add (itemDiamonds); DefaultMutableTreeNode Itemspads = New DefaultMutableTreeNode ("Spades"); AddAllCard (itemSpades); Root.add (itemSpades); DefaultMutableTreeNode item increases = new DefaultMutableTreeNode ("heart"); AddAllCard (itemHearts); Root.add (itemHearts); Default Trimodel Tree Model = New DefaultTreeModel (Route); Tree = new jetty (tree modal); ScrollPane = new JScrollPane (tree); // scrollPane.setViewportView (tree); . ScrollPane.getViewport () add (tr...
Read more

python - Calculate STD manually using Groupby Pandas DataFrame -

-
Image
I was trying to write a solution, which is a different and a manual for calculating a mean and STD The way. I have created a = ["Apple", "Banana", "Cherry", "Apple"] B = [3,4,7,3] C = [5,4,1,4] D = [7,8,3,7] Pd DF = PD to import pandals DataFrame (index = class (4), column = list ("ABCD")) DF ["A"] = A DF ["B"] = BDF ["C"] = C DF ["D"] = D Again, I made a list of A duplication. Then I went through the group all the time of the objects and calculated the solution. import as np l = list (set (df.A)) df.groupby ('A', As_index = False) listMean = [0] * len (df.C) ListSTD = [0] * L in the LAN (df.C) X: s = np.mean (df [df ['A'] == x] for C =.) = Z = [index for index, enumerate In the object (df ['a']. Value] x == item i for z: listMean [i] = s in: s = np.std (df [df ['a'] == X] .cvalues) z = index for index, enumerate item (df ['a']. Value) if x ==...
Read more