What are you trying to accomplish? If you want to tune up CPU, you...

samgdavisne (2/26/2015)

---

Hello,

I am using SQL server 2012 and the operating system is windows server 2012 64 bit.

I am trying to run a batch file from a SQL server agent job....

Well... what's the current performance. Can you post the execution plan? What's the...

Dan121 (2/26/2015)

---

I have one .mdf and two .ndf files on the same drive. The .mdf file size =275GB, one .ndf file size = 300GB and other .ndf file size =...

S_Kumar_S (1/28/2015)

---

After having spent some 13 years with SQL Server and being a Sr. DBA for years, today I just thought of having opinion of other Sr. DBA on "Where...

Did you already read this?

http://blogs.msdn.com/b/dbrowne/archive/2012/05/21/how-to-add-a-hostname-alias-for-a-sql-server-instance.aspx

-- EDIT ---

Disregard, it seems it's the same URL you posted above.

Check sp_stop_job and sp_start_job and see if that helps your logic.

https://msdn.microsoft.com/en-us/library/ms186757.aspx

https://msdn.microsoft.com/en-us/library/ms182793.aspx

+1

Jpotucek (2/25/2015)

---

I have a SQL Server 2012 DB in Full recovery mode that has never had a TLOG backup. the log is huge 200+GB.

I tried doing a transaction...

Thanks for reply.

But no, it won't work.

Careful. xp_delete_file...

Fixed! Geoff helped me. He does not know, lol, but he did. I use this thread as a reference. I basically had a typo.

This is the correct syntax:

PushD "\\servername\share\" &&("forfiles.exe"...

Here is a screenshoot of what I am trying to do:

The command works when running outside of the T-SQL job, let's say, via command prompt. And this is being executed...

Thanks Perry. Appreciate your quick response.

But I am trying to stay away from PowerShell. Besides, above will fail remotely unless I use Set-Location. The command will be executed on a...

GilaMonster (2/20/2015)

---

Agree on that but my comment was...

You must encrypt...