I need to export all jobs into individual files on a regular automated basis.
Is there an easy way to to this?
Can I use the API's that are exposed in Windows to loop through the collection of jobs in a project and export each one into a seperate export file?
Any ideas.
( Sorry if its been covered before, but I couldnt find anything )
Export jobs via Windows API
Moderators: chulett, rschirm, roy
I hope there wont be need for APIs here.
You can write a batch file to export the jobs into individual files. And you can schedule the batch file using Windows Scheduled Tasks.
You can have a sample code Here
You can write a batch file to export the jobs into individual files. And you can schedule the batch file using Windows Scheduled Tasks.
You can have a sample code Here
Rgds
Anand
Anand
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Thanks for the suggestions.
The bat file seems the easiest option and the one we first considered, but the file would need to be maintained with a never ending list of jobs and schedules, currently around 400 per project.
We want to avoid any maintenance so we can be assured were not missing anything.
Thanks
Pat
The bat file seems the easiest option and the one we first considered, but the file would need to be maintained with a never ending list of jobs and schedules, currently around 400 per project.
We want to avoid any maintenance so we can be assured were not missing anything.
Thanks
Pat
HI,
You can get the total list of the job (if update every time) in runtime.
Many option available, somting like dsjob -ljobs... Select NAME from DS_JOBS...
View this to gain idea how to get the total number of jobs in a project.
-Kumar
You can get the total list of the job (if update every time) in runtime.
Many option available, somting like dsjob -ljobs... Select NAME from DS_JOBS...
View this to gain idea how to get the total number of jobs in a project.
-Kumar
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am