Jason Wisdom-380639

Forum Replies Created

Viewing 15 posts - 31 through 45 (of 62 total)

RE: How do I pass a Value to a SQL 2005 Job?

Adam Bean (8/25/2008)
So why bother with SQL? Sounds like VBScript would be a much better, quicker, and cleaner solution. Is the date derived from a table or something?
I don't need...

August 25, 2008 at 2:06 pm

#862777
RE: How do I pass a Value to a SQL 2005 Job?

Yet at this point I'm more curious than anything ... what exactly is it you are doing that is requiring all this? $10 says there is an easier way ...
I...

August 25, 2008 at 1:45 pm

#862765
RE: How do I pass a Value to a SQL 2005 Job?

You can use an Active X step and write vbscript code.
Okay. We could be very close to a solution here.
How can an ActiveX step, using VBScript, execute a DOS...

August 25, 2008 at 12:59 pm

#862735
RE: How do I pass a Value to a SQL 2005 Job?

rbarryyoung (8/25/2008)
Jason Wisdom (8/25/2008)
Steve Jones - Editor (8/25/2008)
I don't think you can do this dynamically directly from a job. You can call a stored proc in the job, build the...

August 25, 2008 at 12:55 pm

#862732
RE: How do I determine Free & Total Space for disk drives, using T-SQL?

rbarryyoung (8/25/2008)
I would suggest that you periodically run a collection agent as a BAT job on the server, but outside of SQL Server that collects this information and then use...

August 25, 2008 at 12:51 pm

#862730
RE: How do I determine Free & Total Space for disk drives, using T-SQL?

princess.lipscomb (8/25/2008)
can you point to why the space runs out so frequently?
maybe you just need to perform maintenance on the db.
Disk space is set to be low...to conserve resources until...

August 25, 2008 at 12:49 pm

#862727
RE: How do I pass a Value to a SQL 2005 Job?

Steve Jones - Editor (8/25/2008)
I don't think you can do this dynamically directly from a job. You can call a stored proc in the job, build the parameter in the...

August 25, 2008 at 10:46 am

#862651
RE: Other Users Cannot Execute SSIS Packages

Hi Brad.
I ran into a similar situation, about 6 months ago.
Try this - not sure if it will work, but it's worth the 5 minutes to try.
Open the package, and...

August 25, 2008 at 10:08 am

#862621
RE: How do I pass a Value to a SQL 2005 Job?

- I'd just like to note that I don't promote the use xp_cmdhsell ... use with caution.
Yes.... I never use xp_cmdshell anymore.
Is there ANY other way to pass a dynamic...

August 25, 2008 at 10:04 am

#862616
RE: How do I pass a Value to a SQL 2005 Job?

In other words, my Job step is a CmdExec routine, calling this line:
"D:\scripts\step1.bat"
What I'm looking to do is instead, pass something like this:
"D:\scripts\step1.bat %1"
Where %1 is a stored value...

August 25, 2008 at 9:56 am

#862609
RE: How do I pass a Value to a SQL 2005 Job?

My main question isn't how to store a date.
My question is, how do I pass a parameter to a batch file in a Job step?

August 25, 2008 at 9:51 am

#862608
RE: How do I pass a Value to a SQL 2005 Job?

What I want is a Job, with 4 steps...each step calls a different DOS batch file, and I want to pass the SAME date to each batch file as a...

August 25, 2008 at 9:36 am

#862596
RE: How do I pass a Value to a SQL 2005 Job?

Jack Corbett (8/25/2008)
What do you mean by completely dynamic? Do you mean you want to be able specify the value each time? For example I may run the job...

August 25, 2008 at 9:35 am

#862595
RE: How do I pass a Value to a SQL 2005 Job?

Jack Corbett (8/22/2008)
How do you want to pass the date value? Do you want to get the current date? Is it a value stored in a database somewhere?
The...

August 25, 2008 at 8:51 am

#862569
RE: How do I roll back orphaned transactions?

Matt Miller (3/13/2008)
Then they're not user transactions. Check out what ALZDBA pointed out. It's background stuff.
I can accept that.. as long as they are not interfering with other...

March 13, 2008 at 2:28 pm

#789324

Viewing 15 posts - 31 through 45 (of 62 total)