RoboTask forum

Even if the SQL failed, I'd still expect an email to come through

OK here's the code I believe I chnaged the task to run with the correct credentials rather than those of the session. It works when ran manually logged in with the credentials. ;***************************** ;* RoboTask Task file ;* Do not edit in text editor! ;***************************** [Root] A...

I have several tasks I write them logged then stop the robotask service and then copy the task from the local profile to the service path and then start the service. It's always worked that way. However the task isn't running - or at least I don't believe it ran cos the email isn't being received I ...

Apologies Oleg.
I used the Dataset loop and got the results appended to a text file.
Brilliant - thanks for the pointer

So it cannot return the results of the SQL query?
It can only come back and say that x rows are involved in the results?

I'm trying to connect to a remote SQL server and run a query It's this query here https://social.msdn.microsoft.com/forums/sqlserver/en-US/38f34421-60b8-4bf4-b779-56e2f1d70cc0/how-to-check-cpu-usage-by-sql Now I presume it connects ok as the initial errors were sorted However the file that gets writ...

Thanks fro that.

I want a task to run every minute The task pings a location once a minute for 8 minutes if those pings fail it is assumed there is a power failure, so initiates a shutdown 2 minutes after sending an email warning of this As you can see there is a potential overlap of several minutes How do i get rou...

Many thanks yet again Oleg.
You're as quick as ever to respond with exactly what is needed.

OK, Iupdated script but now it doesn't like Set objShell = WScript.CreateObject ("WScript.shell") Also F1 for help in script editor give me this error... Why can't I get Help from this program? The Help for this program was created in Windows Help format, which was used in previous version...