sql server dts: How to schedule dts package through web browser? -- sql server dts

Re: How to schedule dts package through web browser?

Allan Mitchell
9/20/2005 7:30:27 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.

[quoted text, click to view]

Re: How to schedule dts package through web browser?

jxf
9/22/2005 12:00:00 AM

thanks, i c
but how to "tell" a scheduler(SQL Server Agent)?

Richard King
jxf

Re: How to schedule dts package through web browser?

jxf
9/22/2005 12:00:00 AM

"sysjobschedules" can do it, right?

Re: How to schedule dts package through web browser?

jxf
9/22/2005 12:00:00 AM

o, must be "sp_update_jobschedule"

Re: How to schedule dts package through web browser?

Allan Mitchell
9/22/2005 12:00:00 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

[quoted text, click to view]

Re: How to schedule dts package through web browser?

jxf
9/22/2005 12:00:00 AM

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
|
[quoted text, click to view]
|
| > thanks, i c
| > but how to "tell" a scheduler(SQL Server Agent)?
| >
| > Richard King
| > jxf
|

Re: How to schedule dts package through web browser?

Allan Mitchell
9/22/2005 12:00:00 AM

Some would say English is not mine either but you explained yourself
well and we have come to a happy ending.

Allan

[quoted text, click to view]

Got something to say? Click here to post a reply to this thread.

Don't see what you're looking for? Try a search.

View other messages in the sql server dts group.