Question
I want to see the status of my server jobs from the past and from the present. How can I do this?

Answer
 

To check the status of your server jobs, you will need access to the SQL Server that houses your RS Database (AeXRSDatabase). There are two tables you will want to look at for this information; MetaJobQueue which shows all jobs that are set to run, but haven't started yet and MetaJobStatus which will list all server jobs that have ran or currently are running.  In both of these tables there are Status columns which show a numerical number in them which represent the outcome of the job. Find the job you are looking for from the Description column and match it Status column code to one of the meanings listed below. 

If you would like to break down and find a specific job and it's status quicker, run the following query against your RS Database (AeXRSDatabase):

Select * from MetaJobStatus
Where MetaJobType = '#' and status = '#'

Replace # with the actual number for the job type and the status. For a list of job types, refer to the MetaJobTypes table.