"Jérémie Gent" <jer_kjr@hotmail.com> wrote in message
news:%23K5tVtPXEHA.2844@TK2MSFTNGP11.phx.gbl...

> You can invoke a job using msdb..sp_start_job. This stored proc can be
> called from an SQL Execute task of DTS packages.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Jérémie Gent" <jer_kjr@hotmail.com> wrote in message
> news:%23K5tVtPXEHA.2844@TK2MSFTNGP11.phx.gbl...
> I'm looking for a solution for my Intranet users (ASP website) to execute
> jobs on my SQL Server
>
> As I don't know all the possibilities of SQL Server, I had thought I could
> do a DTS package, save it as VB source code, compile it in a .exe
> application which my ASP page would execute. I've already done this for
> other packages and it works well
>
> My question is :
> Is it possible to execute a job in a DTS package ? (I've not found this
> option in my DTS Tasks list)
>
> Otherwise, is there a way to create a jobset and save it as a VB source
code
> or maybe execute it directly from a connection object in the ASP Pages ?
>
> Thanks for your help !
> Jérémie
>
>
>

"Jérémie Gent" <jer_kjr@hotmail.com> wrote in message
news:ee3n7GQXEHA.4020@TK2MSFTNGP09.phx.gbl...

> You can invoke a job using msdb..sp_start_job. This stored proc can be
> called from an SQL Execute task of DTS packages.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Jérémie Gent" <jer_kjr@hotmail.com> wrote in message
> news:%23K5tVtPXEHA.2844@TK2MSFTNGP11.phx.gbl...
> I'm looking for a solution for my Intranet users (ASP website) to execute
> jobs on my SQL Server
>
> As I don't know all the possibilities of SQL Server, I had thought I could
> do a DTS package, save it as VB source code, compile it in a .exe
> application which my ASP page would execute. I've already done this for
> other packages and it works well
>
> My question is :
> Is it possible to execute a job in a DTS package ? (I've not found this
> option in my DTS Tasks list)
>
> Otherwise, is there a way to create a jobset and save it as a VB source
code
> or maybe execute it directly from a connection object in the ASP Pages ?
>
> Thanks for your help !
> Jérémie
>
>
>

> But you will have to sort out the permissions issues, around running jobs.
> --
> HTH,
> Vyas, MVP (SQL Server)
> http://vyaskn.tripod.com/
> Is .NET important for a database professional?
> http://vyaskn.tripod.com/poll.htm
>
>
> "Jérémie Gent" <jer_kjr@hotmail.com> wrote in message
> news:ee3n7GQXEHA.4020@TK2MSFTNGP09.phx.gbl...
> OK thank you very much, I'll try that
> (easier would be difficult to find !)
>
> "Narayana Vyas Kondreddi" <answer_me@hotmail.com> schrieb im Newsbeitrag
> news:eMoJw5PXEHA.672@TK2MSFTNGP09.phx.gbl...
> > You can invoke a job using msdb..sp_start_job. This stored proc can be
> > called from an SQL Execute task of DTS packages.
> > --
> > HTH,
> > Vyas, MVP (SQL Server)
> > http://vyaskn.tripod.com/
> > Is .NET important for a database professional?
> > http://vyaskn.tripod.com/poll.htm
> >
> >
> > "Jérémie Gent" <jer_kjr@hotmail.com> wrote in message
> > news:%23K5tVtPXEHA.2844@TK2MSFTNGP11.phx.gbl...
> > I'm looking for a solution for my Intranet users (ASP website) to
execute
> > jobs on my SQL Server
> >
> > As I don't know all the possibilities of SQL Server, I had thought I
could
> > do a DTS package, save it as VB source code, compile it in a .exe
> > application which my ASP page would execute. I've already done this for
> > other packages and it works well
> >
> > My question is :
> > Is it possible to execute a job in a DTS package ? (I've not found this
> > option in my DTS Tasks list)
> >
> > Otherwise, is there a way to create a jobset and save it as a VB source
> code
> > or maybe execute it directly from a connection object in the ASP Pages ?
> >
> > Thanks for your help !
> > Jérémie
> >
> >
> >
>
>
>