Hello,

I currently have a large job created in Sql Server Agent, and I would
like to be able to start the job using either C# or VB.Net. I know I
can start a DTS package with C# but basically this job is very large and
I would like SQl to run it then send a message back when it's finished.

Any help would be appreciated.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can start a job using msdb..sp_start_job stored procedure.
--
HTH,
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
What hardware is your SQL Server running on?
http://vyaskn.tripod.com/poll.htm




"Joe Pelayo" <jpelayo (AT) front-line (DOT) com> wrote



Hello,

I currently have a large job created in Sql Server Agent, and I would
like to be able to start the job using either C# or VB.Net. I know I
can start a DTS package with C# but basically this job is very large and
I would like SQl to run it then send a message back when it's finished.

Any help would be appreciated.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You could use a stored procedure with a return code defined to start the
job and check the status. The return code would tell the calling
application that the DTS package execution has completed.

Cindy Gross, MCDBA, MCSE
http://cindygross.tripod.com
This posting is provided "AS IS" with no warranties, and confers no rights.