Make sure the login that runs SQL Agent runs has permission to access the script and if the script needs to access some other share/machine then login that runs sql...
I've had this problem , where I would forget checking when transaction log backup ran last. I would check for failure of the job, but some one would have disabled...
From my experience never turn on "Auto-Shirnk" option in production database.SQL might starts shirnking database and will hinder the regular SQL operation. I have seen other processes "hang" because of...
Excel probably has an upper limit of 64K rows and your result probably exceeds that limit. I have seen this error while pasting a huge result in to Excel.