Resolved the issue of SP_Helptext which was not showing Storeed procesdure code earlier and throwing error like :- "There is no text for object" and all USP which MrBatch databse...
See, there are lots of other way to solve this TempDB full issue but better and convenient way is that restarting the SQL Server Service which you not want to...
Have you checked SQL Server Agent Properties, Under that you will find History tab and from there you can come to know that ' The current job history log size',...