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 |
|
gongxia649
So Suave
344 Posts |
 Posted - 2007-04-23 : 10:06:37
|
| any keyword shortcut to exec a sql job?do i have to exec step individually when there are more than 2 steps? |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-23 : 10:10:41
|
| No, sql agent will handle it based on step settings. |
 |
|
|
khtan
In (Som, Ni, Yak)
17689 Posts |
Posted - 2007-04-23 : 10:13:00
|
are you referring to the SQL Agent job ?
KH |
|
|
|
gongxia649
So Suave
344 Posts |
Posted - 2007-04-24 : 08:41:53
|
| yes sql agent log |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-24 : 09:34:33
|
| You can start job with msdb..sp_start_job. |
|
|
|
|
|
|
short cut to exec jobs