No one can be positive all the time. You will naturally have periods of doubt. These temporary periods will not hurt you seriously. But a consistently negative attitude that persists for weeks or months will destroy your future with the organization. If you find your negative attitude cannot be improved in your present setting, and you honestly feel such an attitude is justified, you should resign.
A positive attitude is essential to career success for many reasons: