title: How can I determine the status of a job?
body: <p>I have a Stored procedure which schedules a job. This Job takes a lot of time to get completed (approx 30 to 40 min). I need to get to know the status of this Job.
  Below details would help me</p>
  
  <p>1) How to see the list of all jobs that have got scheduled for a future time and are yet to start</p>
  
  <p>2) How to see the the list of jobs running and the time span from when they are running</p>
  
  <p>3) How to see if the job has completed successfully or has stoped in between because of any error.</p>