Displaying posts tagged with

“TSQL”

Script to get Jobs Execution Details

Script to get Jobs Execution Details. This script will give you whole execution details with job started time, job execution time, job finish time, and job execution status. Note: For multiple scheduled jobs it will fetche only last executed job details. You need to create one function for that with name “CONV_DATETIME”. Execute below script [...]

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, [...]

Script to get failed jobs

Script to get failed jobs Below is a TSQL query to get failed jobs last hour. if you want failed jobs for whole day then comment “AND Run_time >= @Ctime” line Regards, Nirav gajjar