Use of tempdb with sql agent/ job

  • Hi there,

    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

  • ignore this email I was on the wrong server (ggot mixed up between our hostspare and live system). !

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply