I have a query which inserts rows to a temp table and depending if there are any rows it sends an email.
This works fine in query analyser, but not in a sql agent job step unless it is a permanent table. Any ideas as to why. I hacve tried a global temporary table but it doesn't seem to work that way either.
Many thanks for any help, Rob