I'm afraid I don't know anything about sql core. Maybe reinstall and ensure the firewall is disabled.

Are you using group policy to apply the firewall rules? Remember it takes some time for the changes to propagate. You can try forcing the policy to apply after making...

If you delete the job and recreate it does it record the history?

Are you sure no one is running dbo.sp_purge_jobhistory to clear the logs?

They are both set to 1000. That means if the job 1 is writing 1000 rows to the job history then you won't see any records for job 2. How...

What are the values in SQL Server Agent Properties > History for

Max job history log size

and

Max Job history rows per job.

Are you referring to MSDB.dbo.sysjobhistory?

How often are the jobs scheduled to run?

If you go into the properties for the SQL Server Agent, under the History page what are the values...

Have you tried creating your view outside of the designer? if you have created a view using the designer then you can use the alter statement along with your view...

<deleted misread question.>

I'm not sure what you are asking. I wouldn't class those records as duplicates. What is it you are trying to achieve.

Just saw the url was in your first post.

So you seem to have 3 ssrs reports being called:

http://localhost/reportserver/P2003/Cover Sheet

http://localhost/reportserver/P2003/Randomization Letter

http://localhost/reportserver/P2003/Starter Sheet

These are what...

Remember this is RSS as in Reporting Services Script not RSS as in the web feed.

Do you know the url to your reporting services server? I would have expected to...

What is the insert for? Are you trying to update the history record if an update has occurred or insert a new history record if an insert has occurred? If...

Think this is what you are looking for..

sys.dm_database_encryption_keys

https://msdn.microsoft.com/en-CA/library/bb677274.aspx

Also you have created a multi statement function so you need to insert into you table variable in order to return data. See below for the differences between and inline...

Try this...

select stuff((select ' ' + oap from @OAP for xml path('')),1,1,'') as myApples