I have some long-running admin scripts that run every day on some of my servers.
I have several print statments in the job that output status and the results of some of the steps. The PRINT statement doesn't seem to output to the screen (or a log file if run from a job) immediatly. I assume it waits until some buffer somewhere fills up then dumps it.
Question: Is there a way to make it immediatly print when I say print, or am I stuck waiting for SQL to decide when it's ready?
The Redneck DBA