ReportingService.CancelJob method and sql connection

If we use the CancelJob method anbd cancel a new/running report, is the
underlying sql connection and process also cancelled/killed/released. I have
not found any documentation on this and am in the process of setting up a
test that will help me determine this.
===================== Thanks!
Keith
p.s. Get off the couch and exercise!This is correct, CancelJob will initiate releasing resources such as
database connections etc.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Keith" <Keith@.discussions.microsoft.com> wrote in message
news:16B983BC-AD60-42AB-8393-2FC43A2CEA40@.microsoft.com...
> If we use the CancelJob method anbd cancel a new/running report, is the
> underlying sql connection and process also cancelled/killed/released. I
> have
> not found any documentation on this and am in the process of setting up a
> test that will help me determine this.
> =====================> Thanks!
> Keith
> p.s. Get off the couch and exercise!|||That's great news, but while researching the help documentation for SRS 2005,
I found this:
Canceling a job only cancels the processes that are running on the report
server. Because the report server does not manage processes on other
computers, you must manually cancel query processes that are subsequently
orphaned on other systems. Consider specifying query time-out values to
automatically shut down queries that are taking too long to execute. For more
information, see Setting Time-out Values for Report Execution. For more
information about temporarily pausing a report, see Pausing Report and
Subscription Processing.
I found this under the topic, "canceling jobs".
Can you shed some light on this discrepancy or explain to me what I am
missing.
Thank you,
Keith
"Robert Bruckner [MSFT]" wrote:
> This is correct, CancelJob will initiate releasing resources such as
> database connections etc.
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Keith" <Keith@.discussions.microsoft.com> wrote in message
> news:16B983BC-AD60-42AB-8393-2FC43A2CEA40@.microsoft.com...
> > If we use the CancelJob method anbd cancel a new/running report, is the
> > underlying sql connection and process also cancelled/killed/released. I
> > have
> > not found any documentation on this and am in the process of setting up a
> > test that will help me determine this.
> >
> > =====================> > Thanks!
> > Keith
> > p.s. Get off the couch and exercise!
>
>