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 |
|
gemsey
Starting Member
2 Posts |
 Posted - 2009-05-27 : 06:45:39
|
| But if anyone could point me in the right direction I'll be so grateful. I'm currently working on a asp page. Basically a user types in an exec name and a stored procedure will be ran. But what we want to see if it works is if we can get a job to run via a stored procedure with a certain variable. I don't know if this possible, but any help will be appreciated. Thanksgemsey aka Pulling-my-hair-out |
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-27 : 06:51:48
|
sp_start_job will start the job for you, from a stored procedure.
E 12°55'05.63"N 56°04'39.26" |
 |
|
|
gemsey
Starting Member
2 Posts |
Posted - 2009-05-27 : 06:54:22
|
| I know that but we want the variable on the job to change to what ever the user has entered. |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2009-05-27 : 07:15:27
|
What is "variable on the job"?
E 12°55'05.63"N 56°04'39.26" |
|
|
|
|
|
|
Have no idea if this is possible...