Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
ismailc
Constraint Violating Yak Guru
290 Posts |
 Posted - 2007-09-12 : 09:13:12
|
| Hi, I would like to create a folder to execute jobs in SQL Server Agent. It's going to be a job but I would like to keep my Daily & monthends seperately. SQL Server Agent - Jobs - create folder under jobsRegards |
|
|
jen
Master Smack Fu Yak Hacker
4110 Posts |
Posted - 2007-09-12 : 09:21:27
|
| you mean a job that will create folders in directory?check xp_cmdshell this will run cmd commands like mkdir--------------------keeping it simple... |
 |
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2007-09-12 : 09:47:58
|
| Hi, No, I want to create folders in the jobs folder. Regards |
|
|
|
ValterBorges
Master Smack Fu Yak Hacker
1429 Posts |
Posted - 2007-09-12 : 10:12:19
|
| Can't do this you can however create categories and assign a category to each job so you can sort them by category.PS: If anyone is interested in a SQL position in CT with excellent pay please contact me at ValterBorges@msn.com |
|
|
|
ismailc
Constraint Violating Yak Guru
290 Posts |
Posted - 2007-09-12 : 10:46:05
|
| Thank You for the advice.I have mailed you regarding the post as I am based in Cape Town.Would like to know more about the post, details please? Regards... |
|
|
|
|
|
|
SQL Server Agent - Jobs - create folder under jobs