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 |
|
sqlhottie
Starting Member
9 Posts |
 Posted - 2007-08-28 : 22:32:11
|
| Since I got such great help before I thought I would post a question that I have been curious about.Is there a way to modify Enterprise Manager JOBS with just sql. For instance if I had a page and I wanted to have a forum that allowed me to change the time a JOB ran. I guess there is no direct sql statement that can change that :)-Jessica |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 22:40:36
|
| Take look at sp_update_job. |
 |
|
|
sqlhottie
Starting Member
9 Posts |
Posted - 2007-08-28 : 22:44:53
|
| Nice thanks.... ah no parameter for [time] :( |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-08-28 : 22:45:51
|
| All listed in books online. |
|
|
|
|
|
|
General question about JOBS