| Author |
How to schedule dts package through web browser?
|
|
|
| Hi all,
DB: SQL Server 2000 Enterprise
how can I schedule dts package through web browser? can I make it be possible by programming?
thanks
| |
| Allan Mitchell 2005-09-20, 8:23 pm |
| The scheduling will not be done by the webpage per se will it? Your web
page will call a scheduler and tell it to execute your package on a
schedule. This could be a 3rd party scheuler, windows scheduler or SQL
Server Agent.
"jxf" <j@j.j> wrote in message
news:#nAdjvavFHA.3400@TK2MSFTNGP14.phx.gbl:
> Hi all,
>
> DB: SQL Server 2000 Enterprise
>
> how can I schedule dts package through web browser? can I make it be
> possible by programming?
>
> thanks
| |
|
| thanks, i c
but how to "tell" a scheduler(SQL Server Agent)?
Richard King
jxf
| |
|
| "sysjobschedules" can do it, right?
| |
|
| o, must be " sp_update_jobschedul
e"
| |
| Allan Mitchell 2005-09-22, 3:23 am |
| Tell it what? To create a new schedule for the job?
If you have many users creating schedules then maybe they will overlap
causing come to not fire?
Allan
"jxf" <j@j.j> wrote in message
news:uy0w0NxvFHA.3152@TK2MSFTNGP12.phx.gbl:
> thanks, i c
> but how to "tell" a scheduler(SQL Server Agent)?
>
> Richard King
> jxf
| |
|
| i have created a procedure to update the schedule.
thank you, Allan.
btw, english is not my mother tongue, so it's very
hard for me to describe my question... :)
"Allan Mitchell" <allan@no-spam.sqldts.com> wrote news:uYKHGYzvFHA.4032@TK2MSFTNGP15.phx.gbl...
| Tell it what? To create a new schedule for the job?
|
| If you have many users creating schedules then maybe they will overlap
| causing come to not fire?
|
| Allan
|
| "jxf" <j@j.j> wrote in message
| news:uy0w0NxvFHA.3152@TK2MSFTNGP12.phx.gbl:
|
| > thanks, i c
| > but how to "tell" a scheduler(SQL Server Agent)?
| >
| > Richard King
| > jxf
|
| |
| Allan Mitchell 2005-09-22, 8:24 pm |
| Some would say English is not mine either but you explained yourself
well and we have come to a happy ending.
Allan
"jxf" <j@j.j> wrote in message
news:u3gvVG0vFHA.3080@tk2msftngp13.phx.gbl:
> i have created a procedure to update the schedule.
> thank you, Allan.
>
> btw, english is not my mother tongue, so it's very
> hard for me to describe my question... :)
>
> "Allan Mitchell" <allan@no-spam.sqldts.com> wrote
> news:uYKHGYzvFHA.4032@TK2MSFTNGP15.phx.gbl...
> | Tell it what? To create a new schedule for the job?
> |
> | If you have many users creating schedules then maybe they will overlap
> | causing come to not fire?
> |
> | Allan
> |
> | "jxf" <j@j.j> wrote in message
> | news:uy0w0NxvFHA.3152@TK2MSFTNGP12.phx.gbl:
> |
> | > thanks, i c
> | > but how to "tell" a scheduler(SQL Server Agent)?
> | >
> | > Richard King
> | > jxf
> |
|
|
|
|