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

1875 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

Check SQL Job timings

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

SCRIPT

Scripting SQL jobs using PowerShell

powershell script can be used to generate scripts for sql jobs with different filenames. I have customised this script in such a way that it will not script any "Replication" or "logshipping" category Jobs. You can modify the script as per your requirement. -------------------------------------------------------------------------------------------- -------------------------------------------------------------------------------------------- Step 1 ... drive as "test" Step 2) Save the script with extension PS1. as "job_script" Step 3) Pass the "instance name" as the parameter. This will create the scripts for the specified instance name. Premjit Das ...