In which database the data(job running details) will load when we run the data manager job from cognos url?
We modified the job to send email notifications when the job was failed in cognos data manager. Its working fine in cognos data manager. But when we publish job as the data movement task and when we try to run it from the cognos insight url we are not getting the job running details in data warehouse so that in notification mail we can't see the error message. Can anyone say in which database/table's the data will load when we run the job from URL.
Thanks,
Sarath.
2 answers
Hello Sarath,
how did you implement the solution to send the email in Data manager?
Which data base were you using?
If it's based on the Catalog database this is not used when running the job as a data movement task.
If it's based on the data warehouse or the content store, they should both be available.
Thanks a lot,
Best Regards
Francesco Chiossi
how did you implement the solution to send the email in Data manager?
Which data base were you using?
If it's based on the Catalog database this is not used when running the job as a data movement task.
If it's based on the data warehouse or the content store, they should both be available.
Thanks a lot,
Best Regards
Francesco Chiossi
Comments
Hi Francesco Chiossi,
Thanks for your quick response. Here we are using content store database. You said both should be available. Can you give more details like which both and where should be available ? And also Can you say exactly into which database table the job running details data will load.
Thanks,
Sarath.
The following are the tables into which the job running details are loading when run the job from cognos data manager.
[dbo].[dsb_audit_msg_line]
[dbo].[dsb_jobnode_run]
[dbo].[dsb_run_context]
[dbo].[dsb_audit_msg]
But when we run it from the URL, the job running details like audit id,error msg etc. are not loading into the mentioned tables.
Thanks,
Sarath