Grant, thanks for your reply.

I neglected to mention in the earlier post that the SQL Server log showed no error at all. There was simply the last valid entry...

There are other more sophisticated ways to do this but here is a quickie example given a simple Policy table such as you describe and requiring no dates to work...

For the new account ABC did you make it a member of the SQLAgent group?

Typically (in Windows) you go into "Control Panel\System & Security\Administrative Tools\Computer Management\Local Users & Groups", click...

For my original query, the plans as provided back in the first post of this thread appeared to show no effective difference between the SELECT vs. the INSERT..SELECT ...

I also...

Thanks very much for all your suggestions so far 🙂 but unfortunately thus far I haven't been able to make much progress on this issue as yet - sorry Patrick.

Jared:...

Here's a list of things you should go through set ensure SQL Agent can fire up correctly. If some of these things aren't done then you can potentially get...