March 11, 2015 at 11:49 pm
Hi,
Is there any sql script using which we can find out all local paths used in job steps and output_file_name path used in advanced settings in in each job step.
Example ) if i have a job which has job steps which out file logging and I need display those jobnames,step id, and command where local paths are used. The reason I wanted to find this output because as we are going for server migration and so we need to create those paths and folders on the new server. I don't want to visit each n every job and look for local paths. That's where i am in search of the script.
Thanks in advance
March 12, 2015 at 12:04 am
sp_Find ':\logs'
In other words I want to list out all jobs steps which has @output_file_name.
March 12, 2015 at 9:33 am
Check out
SELECT * FROM msdb.dbo.sysjobsteps
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply