we've gotten this to work from sqlclr and understand the dependence wcf has on the framework but still feel compelled to ask if somehow t-sql can send a message to a wcf endpoint without getting sqlclr involved. I've moved this question over here from the t-sql forum.
From pure T-SQL; no.Niels
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
For example, before bulk insert, I should uncompress zip files (or untar) from remote machine.
yes possible use the following code...
xp_cmdshell 'Your Command'
|||Thank you very much.
That is what I want.
