Cancel running job
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?
Nicolaas Johannes Van Zyl replied
That would be because the .sp_sjobcontrol you were running is existing in database sybmgmtdb.
So as per your command you are actually saying:
execute sybmgmtdb and within this database run stored procedure called sp_sjobcontrol
This my understanding.