Is it possible to run a VB.Net executable from a SQL job step?

  • (We don't have SQL reporting yet). We currently run a vb.net executable via many Scheduled Tasks to create reports. The Scheduled Tasks can't send out an email telling us if it failed or not. However, a SQL job can. Just wondered if it was possible to execute the vb.net console app from a SQL job. Seems like I've read you can put vb scripting in SSIS - so that may be something to look in to. Thanks for your help!

  • You can run a command line from a job step. Getting the command line to report back a failure properly and give you any useful information would require you actually write out back to the console from your assembly - assuming you have done this, it should work fine.

    If you already have everything written in VB.Net, you could also copy and paste your code and create a CLR stored procedure. You may have to enable unsafe assemblies, but it would allow you to run your reports as stored procedures directly in T-SQL.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply