November 20, 2009 at 1:34 am
I am new to SQL Server 2005 and I want to schedule one .exe file with scheduled job of SQL Server. Can anybody help me out in this.
Thanks in advance.....
November 20, 2009 at 1:38 am
one .exe file? are you calling an application? not sure what you are up to...
but....
In BI, add a process task, and point it to your .exe
save package into SSIS, and schedule it in your agent.
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
This thing is addressing problems that dont exist. Its solution-ism at its worst. We are dumbing down machines that are inherently superior. - Gilfoyle
November 20, 2009 at 3:01 am
Henrico Bekker (11/20/2009)
one .exe file? are you calling an application? not sure what you are up to...but....
In BI, add a process task, and point it to your .exe
save package into SSIS, and schedule it in your agent.
Or just use XP_cmdshell. Its a bit naughty but if you want a quick dirty solution then it works.
Adam Zacks-------------------------------------------Be Nice, Or Leave
November 20, 2009 at 12:19 pm
i need to schedule 1 .exe file thru SQL job..... Its bit complicated but I want it to be done thru SQL job only.
November 20, 2009 at 1:08 pm
Right click jobs -> New Job -> Steps -> New -> Type: CmdExec -> Command: c:\MyFolder\Program.exe
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply