Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-08 : 09:48:50
|
| Richa Bhardwaj writes "Is it Possible to externally send time to a job in SQL server. For example from within a ASP page can I give a interface to the user to create a job and subsequently schedule it. Similarly can i change the time of the job through the ASP page.i.e. I want to give the control to the user to make job schedule presuming that the user does not know any SQL Server.I am aware that a stored procedure called sp_add_jobschedule exsists. But when I try to display the text of the above procedure there is no result. Please help me." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-08 : 10:08:00
|
| The source code for the SP may be invisible (you shouldn't modify it even if you can see it), but you can get all the info you need by using sp_help:EXECUTE sp_help 'sp_add_jobschedule'And the procedure is documented in Books Online too. All you need to do is gather the relevant parameters from your application and you can pass them to sp_add_jobschedule. You may need to use some dynamic SQL to build the full statement, but it's pretty easy. |
 |
|
|
efelito
Constraint Violating Yak Guru
478 Posts |
Posted - 2002-04-08 : 11:11:52
|
| You might also want to check into using SQLDMO as it may be a little eaiser than building all that dynamic SQL....Jeff BanschbachConsultant, MCDBA |
|
|
|
|
|
|
Scheduling Jobs Externally in SQL Server