Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 

1908 Results Found

SCRIPT

Scripting SQL Agents Jobs using Powershell

The script helps to Scripting SQL Agents Jobs using Powershell automatically by scheduling as a job.

SCRIPT

Job failures

simple script that shows failed job steps. You should copy and paste ...

SCRIPT

create jobs script for 2000 2005 or 2008

... ps1filename exec [dbo].[DR_Generate_Script_SQL_Agent_Jobs] @ps1filename = 'c:\downloads\createjobs', @filename ... test for powershell version at end of powershell script for 2008

SCRIPT

SQL Agent Job schedule details

In this script I have attempted to output job name, job description (if any), job owner, job status, job date created, job date modified, job frequenct and job interval. This script will all the jobs except the one that are created by Report Manager to report subscription. Also for the Job Interval, this will only output the value if they are present ...

SCRIPT

Script all the jobs on a SQL server 2005 and apply them in SQL 2008

... output in SQL 2008 to create all the jobs. This is mostly used when the SQL Server ...

SCRIPT

Clear Wait Statistics

... so that the results of the 'Signal and Resource Waits' scripts are more relevant. Wait stats are cumulative ... reflect waits over a shorter timeframe. This script resets those statistics to improve the timeliness ...

SCRIPT

Create SQL JOB to backup database and schedule it

using this script we can create Job for creating backup database. The job will be automatically run in scheduled time. In above script TESTDB is the db to be backedup. 'sa' is loginName ...

SCRIPT

Long Running Jobs Monitor

This script should be executed from the SQL Server ... recurring basis (I run it hourly).  The script will monitor jobs and alert for jobs that run over the specified threshold (Defaults ... have excluded the two Management Datawarehouse Jobs that strt running when the server is brought ...

SCRIPT

Report overlapping jobs

This script reports jobs which are running when another job is also running. This could be a reason for performance degradations. Copy and past this script and run it as a query. Study the outcome to make decisions for shifting the timeframe for a job.

SCRIPT

Check SQL Job timings

... studio. Use msdb database and execute the script. The user should be sysadmin to execute this script.