One of the flags that can be specified for a Sql Agent jobstep is 64 (stop event flag). See the article http://msdn.microsoft.com/en-gb/library/ms187358(v=SQL.110).aspx (in the @flags section). This flag is only allowed for CMDEXEC subsystem jobstep....

If you are using SQL 2012 , please take a look at http://blogs.msdn.com/b/sqlagent/archive/2012/04/05/remove-associated-data-collector-jobs-in-sql-2012.aspx **NOTE**Please use the following script only for testing purpose on TEST systems. T-SQL...

Note: Please use this only when you see failures in data collector tasks and would like to see more details on the root cause. It is recommended to disable this trace settings after you are done with gathering trace logs 1) Create a folder c:\temp...

#launch sqlps.exe to run the followign script #update servername,email profile, recipient list that matches your environment $instanceName = "MACHINE\SQLINSTANCE" $targetFileAnsi = "c:\temp\result_ansi.csv" $targetFileUnicode = "c:\temp\result_unicode...