Displaying posts tagged with

“Jobs Detail”

Script to Remove Jobs History

Script to Remove Jobs History. You can remove jobs history for particular job for a fixed time. Below script will remove history data older then 30 days and where job name is “jobname”. I have used procedure “SP_PURGE_JOBHISTORY” provided by SQL Server, you just need to pass @JobName and @Date as a parameter. You can [...]

Script to get SSIS Jobs

Script to get SSIS Jobs. This script will help you out to get Job Details by category like SSIS,TSQL,etc..   Regards, Nirav Gajjar

Script to get Job Name from Command

Script to get Job Name from Command This script helps to get a job name from command or job script. If you remembered only one word that you have used in your job script and you want to get a job name, this script helps you. Just paste your word instead of “AnyOneWordFromJobScript”.   Regards, [...]