Can i write T-SQL statements to skip other job steps

Hi All,

Please let me know. is it possible to write T-SQL statements in a job step to skip some other job steps.

Regards
Nedu. MOn the 'Advanced' tab of the 'Job Step Properties' you can play with the 'on failure' and 'On Success'.
Ex:
step 1_DO_MY_THING
on success : quit with success
on failure : go to step 2
step 2_REPORT_THE_FAILURE
on success : quit with failure
on failure : quit with failure

In other cases you could merge the steps or save the state somewhere in your db

Can i run two SQl server instances

Dear All,
Can i run two sql server instances if yes than what would be steps .
Thank's
Faheem
NETSOL
> Can i run two sql server instances if yes than what would be steps .
Yes you can. You need to create a named instance while installing the second
sql server instance. This is an option that comes up during the installation
procedure.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinf...2000/books.asp
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:57A297F4-B80F-4448-8CB0-4D6173C0670C@.microsoft.com...
> Dear All,
> Can i run two sql server instances if yes than what would be steps .
> Thank's
> Faheem
> NETSOL
>

Can i run two SQl server instances

Dear All,
Can i run two sql server instances if yes than what would be steps .
Thank's
Faheem
NETSOL> Can i run two sql server instances if yes than what would be steps .
Yes you can. You need to create a named instance while installing the second
sql server instance. This is an option that comes up during the installation
procedure.
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techin.../2000/books.asp
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:57A297F4-B80F-4448-8CB0-4D6173C0670C@.microsoft.com...
> Dear All,
> Can i run two sql server instances if yes than what would be steps .
> Thank's
> Faheem
> NETSOL
>

Can i run two SQl server instances

Dear All
Can i run two sql server instances if yes than what would be steps
Thank'
Faheem
NETSOL> Can i run two sql server instances if yes than what would be steps .
Yes you can. You need to create a named instance while installing the second
sql server instance. This is an option that comes up during the installation
procedure.
--
HTH,
Vinod Kumar
MCSE, DBA, MCAD, MCSD
http://www.extremeexperts.com
Books Online for SQL Server SP3 at
http://www.microsoft.com/sql/techinfo/productdoc/2000/books.asp
"Faheem" <anonymous@.discussions.microsoft.com> wrote in message
news:57A297F4-B80F-4448-8CB0-4D6173C0670C@.microsoft.com...
> Dear All,
> Can i run two sql server instances if yes than what would be steps .
> Thank's
> Faheem
> NETSOL
>