How to remove oracle job which is scheduled through windows?

[urfriend_friendy]

Hi,
Other day, I scheduled a procedure using toad 9.5 wizard.( I did so by
right-clicking in the navigation-pane of schema browser under 'Jobs'
tab) Instead of clicking 'OK', I scheduled it.Wizard prompted for
operating system (windows) user-id and password, which I supplied.Itz
running daily @ 4:10 pm from my system through 'Quest script runner'.


Note that I didn't supply explicit 'Commit' to the
aforementioned 'dbms_job.submit' script that I scheduled to run daily.

So, daily the 'quest script' is submitting my procedure
through 'dbms_job.submit' without any commit.

(Also Note that I don't have grants to see all the user jobs in Toad.)


Could you please help me in disabling it?

[Jeff Smith-7]

It sounds like you scheduled it as a Windows job, not as an Oracle job.

If you have the DB Admin module you can use this screen to manage it, otherwise, just go to your Windows control panel and look up your tasks.  Look for one that has a call to 'qsr.exe' and disable it or delete it.

[cid:image001.png@...]

From: toad@... [mailto:toad@...] On Behalf Of urfriend_friendy
Sent: Monday, October 06, 2008 8:24 AM
To: toad@...
Subject: [toad] How to remove oracle job which is scheduled through windows?


Hi,
Other day, I scheduled a procedure using toad 9.5 wizard.( I did so by
right-clicking in the navigation-pane of schema browser under 'Jobs'
tab) Instead of clicking 'OK', I scheduled it.Wizard prompted for
operating system (windows) user-id and password, which I supplied.Itz
running daily @ 4:10 pm from my system through 'Quest script runner'.

Note that I didn't supply explicit 'Commit' to the
aforementioned 'dbms_job.submit' script that I scheduled to run daily.

So, daily the 'quest script' is submitting my procedure
through 'dbms_job.submit' without any commit.

(Also Note that I don't have grants to see all the user jobs in Toad.)

Could you please help me in disabling it?


 

[George.Meltser]

One of my coworker's PC crashed last night and now the above mentioned file is empty. So he lost all his queries.
Is there a backup somewhere in TOAD?

The version he is running is 8.6.1.0

[urfriend_friendy]

Jeff Smith,

Thanx for the prompt reply!!!

--- In toad@..., Jeff Smith <jeff.smith@...> wrote:
>
> It sounds like you scheduled it as a Windows job, not as an Oracle job.
>
> If you have the DB Admin module you can use this screen to manage
it, otherwise, just go to your Windows control panel and look up your
tasks.  Look for one that has a call to 'qsr.exe' and disable it or
delete it.
>
> [cid:image001.png@...]
>
> From: toad@... [mailto:toad@...] On Behalf
Of urfriend_friendy
> Sent: Monday, October 06, 2008 8:24 AM
> To: toad@...
> Subject: [toad] How to remove oracle job which is scheduled through
windows?

>
>
> Hi,
> Other day, I scheduled a procedure using toad 9.5 wizard.( I did so by
> right-clicking in the navigation-pane of schema browser under 'Jobs'
> tab) Instead of clicking 'OK', I scheduled it.Wizard prompted for
> operating system (windows) user-id and password, which I supplied.Itz
> running daily @ 4:10 pm from my system through 'Quest script runner'.
>
> Note that I didn't supply explicit 'Commit' to the
> aforementioned 'dbms_job.submit' script that I scheduled to run daily.
>
> So, daily the 'quest script' is submitting my procedure
> through 'dbms_job.submit' without any commit.
>
> (Also Note that I don't have grants to see all the user jobs in Toad.)
>
> Could you please help me in disabling it?
>