|
|
|
| hi,
Can I create a job like this in sql 2k?
exec EVO_SP_CUSTReindex
go
SP_updatestats
go
Does the second step will run?
Thnaks
| |
|
| exec EVO_SP_CUSTReindex
go
SP_updatestats
go
all in one step
"mecn" <mecn2002@yahoo.com> wrote in message
news:OMx0fuQKGHA.1288@TK2MSFTNGP09.phx.gbl...
> hi,
>
> Can I create a job like this in sql 2k?
>
> exec EVO_SP_CUSTReindex
> go
> SP_updatestats
> go
>
> Does the second step will run?
>
> Thnaks
>
| |
| Quentin Ran 2006-02-03, 8:23 pm |
| Yes just put the code in one step.
"mecn" <mecn2002@yahoo.com> wrote in message
news:OdUNJ5QKGHA.2628@TK2MSFTNGP15.phx.gbl...
> exec EVO_SP_CUSTReindex
> go
> SP_updatestats
> go
>
> all in one step
>
> "mecn" <mecn2002@yahoo.com> wrote in message
> news:OMx0fuQKGHA.1288@TK2MSFTNGP09.phx.gbl...
>
>
| |
| Sreejith G 2006-02-05, 1:23 pm |
| Both are TSQL type and you need to spcify the right DBName is Database
selection drop down while creating jobs...
Thanks,
Sree
"mecn" wrote:
> exec EVO_SP_CUSTReindex
> go
> SP_updatestats
> go
>
> all in one step
>
> "mecn" <mecn2002@yahoo.com> wrote in message
> news:OMx0fuQKGHA.1288@TK2MSFTNGP09.phx.gbl...
>
>
>
|
|
|
|