topic VBScript not running manually or in task scheduler in SAS Procedures

VBScript not running manually or in task scheduler

DpDiane — Sat, 29 Mar 2014 14:44:32 GMT

Hi,

Can somebody tell me what is wrong with the code below? It wont run manually or with the task scheduler. It has worked in the past but stopped working for some reason.

Any help would be much appreciated.

Option Explicit
Dim app
Dim container
Dim orderedList
Dim n
Dim p

Call dowork

If not (app Is Nothing) Then
app.Quit
Set app = Nothing
End If

Sub dowork()
    On Error Resume Next
    Dim prjName
    Dim prjObject

    prjName = "C:\My Data\ReportDocs_DRC_Daily_Sales\SAS_DailySales.egp"

    Set app = WScript.CreateObject("SASEGObjectModel.Application.4.3")

Set prjObject = app.Open(prjName,"")

Set container = prjobject.ContainerCollection

For n=0 to (container.Count -1)

                if container(n).ContainerType = 5 then
                Set orderedList = container(n).Items
                  for p=0 to (orderedList.Count -1)
                                orderedList(p).run
                  Next
                end if
    Next

    prjObject.run
    prjObject.Save
    prjObject.Close

End Sub

Re: VBScript not running manually or in task scheduler

Doc_Duke — Mon, 31 Mar 2014 12:40:19 GMT

"Doesn't run" is pretty broad. Any specifics? I'm not a VB programmer, so I can't help on the specifics of the code.

In general, if something that used to run, stops running, I look for changes in the environment. Can you still run any scheduled tasks? Perhaps IT removed or restricted that capability for users. New OS? Other new software?

Re: VBScript not running manually or in task scheduler

DpDiane — Mon, 31 Mar 2014 18:27:57 GMT

Hi,

The script use to run on my old laptop with Windows 7 but recently upgraded to a new machine. The script opens the SAS query, closes and saves it but doesnt run the actually query. i can tell because the time on the query has changed. Could it be a system setting I need to change?

Any help would be great.

Thanks,

Diane

Re: VBScript not running manually or in task scheduler

Doc_Duke — Tue, 01 Apr 2014 13:32:02 GMT

See if you can run anything from vb?

See if you can run an EG project with the scheduler?

Then get up with your IT support folks.

Re: VBScript not running manually or in task scheduler

DpDiane — Thu, 03 Apr 2014 16:18:51 GMT

I have escalated this to the IT Folks as I think it could be an system setting on my laptop. I can run it on my old laptop no problem.

Thanks so much for your help.