Post reply

Terminate the job

  • September 22, 2005 at 6:28 am

    #111779

     

    Hi All,

    An application Scheduler kicks off a job,which runs the RECWIN.exe executable on the server, and its scheduled to run for 1 hour and the job is still running 4 hours later,how do i proceed to terminate the job on server.

    As this is my first experience with this type of problems i dont know much about it.can anyone Please Help??

    Thanks in Advance

    Kindest Regards,

    Jeetendra

  • September 22, 2005 at 6:52 am

    #592173

    You can terminate a job via Enterprise Manager - right click on job and select "Stop Job"







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 22, 2005 at 7:01 am

    #592178

    Sushila,

    If i could have seen the Job in Enterprise Manager I would have deleted it.Its running via some scripts using some batch files.

    And i wanna know how to stop the job?

    Anyway Thanks for the Answer as i was really not knowing that....

    "Coming together is a beginning, staying together is progress, and working together is success."

    Kindest Regards,

    Jeetendra

  • September 22, 2005 at 7:10 am

    #592185

    Can't you just kill that process (assuming it's not vital to sql server)?

  • September 22, 2005 at 7:11 am

    #592186

    aah - took the words out of my mouth...maybe stop the sql server agent another option ?!







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 22, 2005 at 11:18 pm

    #592473

    Sushila,

    Okie, I Stop the Agent and restarted it.

    But What If it would have been a Production Server(24x7),What are other Possible ways of doing it?

    Thanks.

    Kindest Regards,

    Jeetendra

  • September 23, 2005 at 2:16 am

    #592512

    Set timeouts on components within the package.

    As far as I know, there's no way to set timeout for the entire package.

    ***

  • September 23, 2005 at 7:12 am

    #592585

    what about the sysjobs system table...?!?! I should think that you may be able to directly disable/delete a specific job (without affecting the other jobs) using the job_id...?!?!







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 23, 2005 at 7:15 am

    #592590

    I have no idea why that "funky display" just happened....







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 23, 2005 at 7:15 am

    #592589

    Stop using the table html markups (incorrectly at least) .

  • September 23, 2005 at 7:15 am

    #592588

    I can't wait to see where this message will end up!!!

  • September 23, 2005 at 7:17 am

    #592592

    Hey 6000 posts...how come the "label" still says 5000 ?!?!

    I'm checking the display on this one too...testing out a theory!!!







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 23, 2005 at 7:18 am

    #592593

    DID NOT....all I did was hit the "reply with quote" button...







    **ASCII stupid question, get a stupid ANSI !!!**

  • September 23, 2005 at 7:26 am

    #592597

    Try to edit your message using netscape... you'll see any markups and formatting there.

    I guess that the next step is 10K .

  • September 23, 2005 at 7:40 am

    #592604

    I cannot "edit" my post at all...it's now "joined at the hip" with ziggy starlight's post..

    I think the "next step" hasn't been implemented at all since steve must not have anticipated any one person who combines being an RG & an US all in one...think I shall go post something in "Anything but SQL.." on this...







    **ASCII stupid question, get a stupid ANSI !!!**

Viewing 15 posts - 1 through 15 (of 18 total)

You must be logged in to reply to this topic. Login to reply