Skip to Content

Cancel running job


Hi experts,

I've scheduled a job which is running to long and I want to cancel now.

The scheduling I have done via DBACOCKPIT, as there is no option to cancel in, I guess I have to do that in isql.

However, what is the command for that?

Kind regards

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on May 21, 2015 at 01:26 PM

    Hi Martin,

    Do you know the job name?

    SyBooks Online

    Can you see the job running with sp_who perhaps? it should run under sapsa user.

    Kind Regards,

    Johan

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 21, 2015 at 01:07 PM

    I have already found sp_sjobcontrol, however, "stored procedure is not found".

    Kind regards

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.