Post reply

SQL Agent Job Status

  • February 5, 2009 at 1:11 pm

    #130819

    I am running a job and it is running for 8 hrs now and still am not sure how long it will take to complete. Is there a way i can check % of job comepleted for an ongoing job.

  • February 5, 2009 at 3:36 pm

    #939252

    If you know what the job is doing, you may check the status (percent-complete, estimated complete time) in sys.dm_exec_requests if you could figure out the sessionid, requestid etc...

  • February 6, 2009 at 9:09 am

    #939612

    But with that i dont see any % of completion of my Job.

  • February 6, 2009 at 9:39 am

    #939632

    I am looking to check the status of my job step. one of the step in hte job is running for severeal hours. How can i check how much % of that job step is done.

    thanks

  • February 6, 2009 at 9:51 am

    #939645

    I don't know of any out-of-the-box mechanism for what you seek, and if there is one built-in, then I really want to know about it, as well.

    "Got no time for the jibba jabba!"
    -B.A. Baracus

Viewing 5 posts - 1 through 4 (of 4 total)

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