Unknown object type '***' used in a CREATE, DROP, or ALTER statement.

Normally, we facing the error when we try to Create/Alter/Drop an object without specifying the Object Type(i.e: Table, Proc, Etc,..)

Create TestData
(
Column1 Varchar(15),
Column2 Varchar(15)
)

(or)

Create Sproc_Test1
As
Begin
Select GETDATE() [CDate]
End
 
In both script given above, We missedout the object type(which object we going to perform "Create"). we have missed out Table, Proc object type respectively in the scripts given above.
 
The actual script should be like as follows 
 
Create Table TestData
(
Column1 Varchar(15),
Column2 Varchar(15)
)

(or)

Create Proc Sproc_Test1
As
Begin
Select GETDATE() [CDate]
End

Job last run information

Use msdb
Go

Declare @job_id UniqueIdentifier
Select @job_id = Job_Id from sysjobs Where name='Job Name'
EXEC sp_help_jobserver @job_id = @job_id, @show_last_run_details = 1
Go