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 |
|
learntsql
524 Posts |
 Posted - 2010-02-24 : 00:02:42
|
| Hi..I have scheduled a report to run everyday as subscription.It has created some jobs and showing under SQL Agent tab.How to identify the jobs created for this perticuler subscription.?Now my requirement is i want to disable these jobs for few days.how to do that?TIA. |
|
|
learntsql
524 Posts |
Posted - 2010-03-04 : 04:58:05
|
| Any Ideas please.... |
 |
|
|
ahmad.osama
Posting Yak Master
183 Posts |
Posted - 2010-03-04 : 05:45:15
|
quote:
Originally posted by learntsql
Hi..I have scheduled a report to run everyday as subscription.It has created some jobs and showing under SQL Agent tab.How to identify the jobs created for this perticuler subscription.?Now my requirement is i want to disable these jobs for few days.how to do that?TIA.
u should look for disabling the subscription..anyways u can query sysjobs table and check the name and description to identify particular ones. |
|
|
|
|
|
|
Find Job Names