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 tried that , it returns zero.I recreated the Index and it fixed the problem.

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...

The only reason that coverting date to char will fail is if you have "odd" values in date field. You can find this out be

Select * from table where...

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.

Thanks