Thank you for the responses.

So in the end I just made the user account an owner of the schema as it turns out they didn't need to create objects.

Also found...

Thank you for the responses.

We do have an index job but this runs at night and had completed by the looks of it.

In the end I...

Ok makes sense thank you.

So running a truncate and then database shrink should be ok?

Ok when I can get onto the server I will see if I can find out. Thank for your help guys.

and yes it is running as per the created schedule its just showing as disabled.

Just says Executed as user: NT SERVICE\SQLAgent. The step succeeded.

So I have put in the name of the job and ran the script and it shows the job as enabled but the is schedule enabled column there is a...

Found that its the SQL agent, when I go into manage schedules and then find the correct one, then steps and then jobs in schedule and it shows as enabled.

Thank John, that returns no results, do you think It could be a PowerShell set up on the server, I don't have direct access so I cannot check at the...

Thank you both for the help, I cannot see any notifications set up and I have checked the code and I cannot see an sp_start_job. any other ideas?