Running EG tasks from inside Visual Basic code

[Oleg]

Morning everybody!

Could anybody point me links to good instructions/tutorials/samples how to run EG tasks from VB code (EG 4.1 – I have found some samples for older ones).

I have found couple of instructions, how to run VB tasks (addins) from inside EG, but I looking opposite solution – how to run EG from inside VB(.NET) code.

What I looking for:
Maximum target is the small solution which enables preparing simple EG workflows and then run this workflow from Visual Basic ( even better would be to run from VB, which are launched from IIS page in same machine). In this way I would be able to prepare a small workstation for business analyst, who preparing workflows and enable for two or three less-analytical colleagues to run his prepared tasks through intranet web server (IIS) installed in the same machine. So in this way to share his/her work without calling colleagues to watch results over his/her shoulder.
Performance is not a problem as requests to run tasks happen probably just couple times in day. If it would be a problem, that means a need to obtain server platform.

Minimum target is to run local SAS programs from Visual Basic (again - even better would be to run from VB, which are launched from IIS page in same machine). Purpose is same as in maximum target – to share results (HTML outputs) with one-two-three colleagues.

I have worked a lot with VB (mostly VB6 unfortunately). In current tests I achieved, that I am able to run SAS programs from VB.NET. I can imagine, that should be easy to connect this VB code to local IIS. But my impression is , that in some way it must be possible to run even EG tasks from VB (can be also C# , or even Java).

I have not found proper tutorials/samples/instructions. Sample would be excellent. I am experienced developer (>20 years) and used to leverage simple samples with parallel learning to working solutions.

And another question. Is it correct, that such infrastructure requires SAS IT Windows client (not a full SA Integration Technologies). And client software (actually set of DLLs) is free of charge.

Thanks in advance for any ideas
/oleg

[deleted_user]

YOu misunderstand what EG is. EG is a front end tool to SAS. What you really want to do is to run a SAS process from EG.

If the process was created within EG, you have to package that up, as if you were to have the Microsoft Task Scheduler run it for you, but then, instead, have VB make issue the system call to run the process.

2 clues
1) How would you have VB run a dos .bat file?
2) How would you get MS Task Scheduler to run an EG process.

Then marry these two together, and waza, happiness.

[Oleg]

Chuck!

I am really sad 🙂

You catched excellently the idea an dexpressed it in couple of sentences.
That's really what I want to do - create quite simple workflow, which ends with HTML output and call it from local IIS (on request - not as scheduled service).

So - I start investigate Your suggestion - seems that running this vbscript created by scheduling process should be best solution.

thanks
/oleg

[darrylovia]

Hey what we've done is create a stored process in EG and then have .NET call it.

This may point you in the right direction
http://support.sas.com/rnd/itech/doc9/dev_guide/dist-obj/winclnt/windotnet.html



-Darryl