Possible to access SQL Agent through ASP?

[Kaisa M. Lindahl]

Is it possible to access the SQL Agent through ASP code?
My case is this:
I want to run a job every hour, every day between 08 am and 4 pm, as that is when people are in the office. Then, I might want to change it to run every hour from 9am to 5 pm. I want to do this without bothering the IT-guys, so I want to have a simple asp-page where I can change the to and from settings of the job. Is this possible? And how? What do I have to access ?

Any comments will be appreciated!

Yours,
Kaisa M. Lindahl

[Ray Miao]

You can run msdb..sp_update_jobschedule in asp.


------------
Kaisa M. Lindahl at 5/7/2002 6:02:50 AM

Is it possible to access the SQL Agent through ASP code?
My case is this:
I want to run a job every hour, every day between 08 am and 4 pm, as that is when people are in the office. Then, I might want to change it to run every hour from 9am to 5 pm. I want to do this without bothering the IT-guys, so I want to have a simple asp-page where I can change the to and from settings of the job. Is this possible? And how? What do I have to access ?

Any comments will be appreciated!

Yours,
Kaisa M. Lindahl