Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 537
  • Last Modified:

sysjobs vs sysdtspackages

if there are entries in sysjobs, but none in sysdtspackages, what does it mean?

thanks
0
anushahanna
Asked:
anushahanna
2 Solutions
 
Larissa TCommented:
Not all packages has to be scheduled as jobs and not all jobs have corresponding DTS package
0
 
PrakashRaoBSCommented:
If you are not scheduled the dts package, then sysdtspackages table has an entry and sysjobs doesn't have an entry.

If you scheduled the job which doesn't contains any excution of DTS packages or SSIS packages, then sysjobs tables has an entry, but the sysdtspackages table doesn't have an entry.
0
 
anushahannaAuthor Commented:
Thank you. helpful.
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now